corpus.blog
56,966 blogs · [ { "id": "01a0d1d3-bae4-70c8-82f2-da41622a60e3", "title": "In-memory enhancements and improvements in SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/06/14/in-memory-enhancements-and-improvements-in-sql-server-2016/", "published_at": "2015-06-14T01:30:59+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4162d3b3fc", "title": "Leap Second coming this June 2015, will it affect SQL Server?", "url": "https://sqlwithmanoj.com/2015/06/13/leap-second-coming-this-june-2015-will-it-affect-sql-server/", "published_at": "2015-06-13T01:30:41+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41631d557f", "title": "T-SQL Query solution to ‎SSGAS2015‬ 2nd Question/Challenge – SQL Server Geeks", "url": "https://sqlwithmanoj.com/2015/06/12/t-sql-query-solution-to-%e2%80%8essgas2015%e2%80%ac-2nd-questionchallenge-sql-server-geeks/", "published_at": "2015-06-12T01:30:00+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4163983b59", "title": "This blog just crossed one million hits – Thanks!!!", "url": "https://sqlwithmanoj.com/2015/06/11/this-blog-just-crossed-one-million-hits-thanks/", "published_at": "2015-06-11T01:30:36+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41639e0b56", "title": "ColumnStore Indexes evolution from SQL Server 2012, 2014 to 2016", "url": "https://sqlwithmanoj.com/2015/06/08/columnstore-indexes-evolution-from-sql-server-2012-2014-to-2016/", "published_at": "2015-06-08T01:30:31+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416400c286", "title": "Limitations of SQL Server Express Edition", "url": "https://sqlwithmanoj.com/2015/06/07/limitations-of-sql-server-express-edition/", "published_at": "2015-06-07T05:13:29+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41649e3476", "title": "Now truncate “Table Partitions” with TRUNCATE TABLE statement – SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/06/04/now-truncate-table-partitions-with-truncate-table-statement-sql-server-2016/", "published_at": "2015-06-04T01:30:36+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4164ee10ec", "title": "See Execution Plans running with Live Query Statistics – SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/06/03/see-execution-plans-running-with-live-query-statistics-sql-server-2016/", "published_at": "2015-06-03T01:30:34+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4165d5b7f3", "title": "Enable Query Store on a Database – SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/06/02/enable-query-store-on-a-database-sql-server-2016/", "published_at": "2015-06-02T01:30:27+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4166aa92ea", "title": "Export/Convert Table or SQL Query data to JSON string format | SQL Server 2016 – Part 1", "url": "https://sqlwithmanoj.com/2015/06/01/exportconvert-table-or-sql-query-data-to-json-string-format-sql-server-2016-part-1/", "published_at": "2015-06-01T01:30:18+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4167a9b8ed", "title": "SQL DBA – Windows could not start the SQL Server… refer to service-specific error code 17051 – SQL Server Evaluation period has expired", "url": "https://sqlwithmanoj.com/2015/05/31/windows-could-not-start-the-sql-server-refer-to-service-specific-error-code-17051-sql-server-evaluation-period-has-expired/", "published_at": "2015-05-31T04:30:12+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4168491782", "title": "Query Store – new feature in SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/05/30/query-store-new-feature-in-sql-server-2016/", "published_at": "2015-05-30T01:30:30+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41691f3f2c", "title": "Installing SQL Server 2016 CTP2 | and new features in SSMS", "url": "https://sqlwithmanoj.com/2015/05/29/installing-sql-server-2016-ctp2-and-new-features-in-ssms/", "published_at": "2015-05-29T01:30:18+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4169fdae57", "title": "Microsoft SQL Server 2016 Public Preview (CTP2) Available – download now", "url": "https://sqlwithmanoj.com/2015/05/28/microsoft-sql-server-2016-public-preview-ctp2-available-download-now/", "published_at": "2015-05-27T18:30:51+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416a928d07", "title": "Native JSON support – new feature in SQL Server 2016", "url": "https://sqlwithmanoj.com/2015/05/27/native-json-support-new-feature-in-sql-server-2016/", "published_at": "2015-05-27T02:30:00+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416ae16702", "title": "Reading XML data in SQL Server – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/05/26/reading-xml-data-in-sql-server-msdn-tsql-forum/", "published_at": "2015-05-26T10:20:22+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416ba6b8a4", "title": "SQL Myth | Nested Transactions in SQL Server and hidden secrets", "url": "https://sqlwithmanoj.com/2015/05/26/sql-myth-nested-transactions-in-sql-server-and-hidden-secrets/", "published_at": "2015-05-26T06:15:48+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416c319f48", "title": "SQL error – Msg 6401, Level 16, State 1 – Cannot roll back Transaction. No transaction or savepoint of that name was found", "url": "https://sqlwithmanoj.com/2015/05/25/sql-error-msg-6401-level-16-state-1-cannot-roll-back-transaction-no-transaction-or-savepoint-of-that-name-was-found/", "published_at": "2015-05-25T02:30:16+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416c592884", "title": "SQL Myth | Primary Key (PK) always creates Clustered Index", "url": "https://sqlwithmanoj.com/2015/05/24/sql-myth-primary-key-pk-always-creates-clustered-index/", "published_at": "2015-05-24T06:51:00+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416d2afb34", "title": "SQL Basics – Difference between WHERE, GROUP BY and HAVING clause", "url": "https://sqlwithmanoj.com/2015/05/23/sql-basics-difference-between-where-group-by-and-having-clause/", "published_at": "2015-05-23T12:49:57+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416dc5eafc", "title": "Getting started with SQL Server 2014 | Download and Install Free (Express) or Full version", "url": "https://sqlwithmanoj.com/2015/05/19/getting-started-with-sql-server-2014-download-and-install-free-express-or-full-version/", "published_at": "2015-05-18T18:49:11+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416ea06ce2", "title": "SQL Recovery utility by SysTools | easily Recover your corrupt Database in few clicks", "url": "https://sqlwithmanoj.com/2015/05/14/sql-recovery-utility-by-systools-easily-recover-your-corrupt-database-in-few-clicks/", "published_at": "2015-05-14T07:45:06+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da416f90bcae", "title": "Microsoft announced SQL Server 2016 – New features and enhancements", "url": "https://sqlwithmanoj.com/2015/05/09/microsoft-announced-sql-server-2016-new-features-and-enhancements/", "published_at": "2015-05-08T21:08:09+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41705301c3", "title": "What is SQL, PL/SQL, T-SQL and difference between them", "url": "https://sqlwithmanoj.com/2015/05/03/what-is-sql-plsql-t-sql-and-difference-between-them/", "published_at": "2015-05-03T12:29:36+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4170566ca9", "title": "Preparing for 70-462 Exam : Administering Microsoft SQL Server 2012 Databases | Certification", "url": "https://sqlwithmanoj.com/2015/05/01/preparing-for-70-462-exam-administering-microsoft-sql-server-2012-databases-certification/", "published_at": "2015-05-01T14:34:36+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4170d71f21", "title": "SQL Error – SQLState = S0002 NativeError = 208 [SQL Server Native Client 11.0][SQL Server]Invalid object name ‘xyztable’ Unable to resolve column level collations", "url": "https://sqlwithmanoj.com/2015/04/16/sqlstate-s0002-nativeerror-208-sql-server-native-client-11-0sql-serverinvalid-object-name-xyztable-unable-to-resolve-column-level-collations/", "published_at": "2015-04-16T13:16:30+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4170f8c477", "title": "DDL and DML in Single Script with GO (batch separator) – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/04/16/ddl-and-dml-in-single-script-with-go-batch-separator-msdn-tsql-forum/", "published_at": "2015-04-16T12:17:52+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41710b90b3", "title": "Table to store MS Word docs, only be accessible via SQL Queries – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/04/15/table-to-store-ms-word-docs-only-be-accessible-via-sql-queries-msdn-tsql-forum/", "published_at": "2015-04-15T11:44:48+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4171e1d506", "title": "SQL Error – Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1 SQL Server blocked access because this component is turned off", "url": "https://sqlwithmanoj.com/2015/04/14/msg-15281-level-16-state-1-procedure-xp_cmdshell-line-1-sql-server-blocked-access-because-this-component-is-turned-off/", "published_at": "2015-04-14T05:00:00+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4172497e98", "title": "Export XML column data to a file.xml", "url": "https://sqlwithmanoj.com/2015/04/13/export-xml-column-data-to-a-file-xml/", "published_at": "2015-04-13T12:17:34+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417336d6b7", "title": "Error Msg 7302, Cannot create an instance of OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/04/10/error-msg-7302-cannot-create-an-instance-of-ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-msdn-tsql-forum/", "published_at": "2015-04-10T12:26:09+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4173bfb34d", "title": "String concatenation resulting NULL values – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/04/09/string-concatenation-resulting-null-values-msdn-tsql-forum/", "published_at": "2015-04-09T10:56:17+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417454a78d", "title": "DELETE from Parent and all its child tables with Foriegn Key (no DELETE ON CASCADE) – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/04/08/delete-from-parent-and-all-its-child-tables-with-foriegn-key-no-delete-on-cascade-msdn-tsql-forum/", "published_at": "2015-04-08T11:31:11+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41750d1dd8", "title": "Index Usage Stats – Indexes Used, Unused and Updated", "url": "https://sqlwithmanoj.com/2015/04/02/index-usage-stats-indexes-used-unused-and-updated/", "published_at": "2015-04-02T14:17:50+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4175f80791", "title": "Standardize TRY CATCH block across all Stored Procedures – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/03/31/standardize-try-catch-block-across-all-stored-procedures-msdn-tsql-forum/", "published_at": "2015-03-31T13:15:31+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4175fb277e", "title": "SQLNCLI11 for linked server “XYZ” returned message “Requested conversion is not supported” | SQL Server 2012 upgrade behavior changes", "url": "https://sqlwithmanoj.com/2015/03/27/sqlncli11-for-linked-server-xyz-returned-message-requested-conversion-is-not-supported-sql-server-2012-upgrade-behavior-changes/", "published_at": "2015-03-27T14:34:30+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4176831d29", "title": "GROUPING SETS equivalent | for SQL Server 2005 and below", "url": "https://sqlwithmanoj.com/2015/03/23/grouping-sets-equivalent-for-sql-server-2005-and-below/", "published_at": "2015-03-23T15:56:41+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41769aee7d", "title": "Dynamic SQL usage, when to use? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2015/03/04/dynamic-sql-usage-when-to-use-msdn-tsql-forum/", "published_at": "2015-03-04T11:23:30+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41769be962", "title": "SQL Basics – What are Row Constructors?", "url": "https://sqlwithmanoj.com/2015/02/16/sql-basics-what-are-row-constructors/", "published_at": "2015-02-16T01:30:47+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41773f9a02", "title": "Capture multiple errors in TRY CATCH by using THROW statement", "url": "https://sqlwithmanoj.com/2015/02/04/capture-multiple-errors-in-try-catch-by-using-throw-statement/", "published_at": "2015-02-04T07:26:52+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4177bc9124", "title": "Microsoft’s upcoming USCMO Webcasts | Digital Events", "url": "https://sqlwithmanoj.com/2015/01/16/microsofts-upcoming-uscmo-webcasts-digital-events/", "published_at": "2015-01-16T05:14:09+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da41787e555d", "title": "SQL Error – Index (zero based) must be greater than or equal to zero and less than the size of argument list", "url": "https://sqlwithmanoj.com/2015/01/11/sql-error-index-zero-based-must-be-greater-than-or-equal-to-zero-and-less-than-the-size-of-argument-list/", "published_at": "2015-01-11T02:30:13+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417966d540", "title": "2014 in review", "url": "https://sqlwithmanoj.com/2014/12/30/2014-in-review/", "published_at": "2014-12-30T04:05:53+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da4179fcbfef", "title": "What is ODS (Operational Data Store) and how it differs from Data Warehouse (DW)", "url": "https://sqlwithmanoj.com/2014/12/17/what-is-ods-operational-data-store-and-how-it-differs-from-data-warehouse-dw/", "published_at": "2014-12-17T13:55:38+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417ab17afb", "title": "Using GROUPING SETS | SQL Server 2008 and above", "url": "https://sqlwithmanoj.com/2014/11/20/using-grouping-sets-sql-server-2008-and-above/", "published_at": "2014-11-20T04:44:15+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417b6d7887", "title": "Self Service BI by using Power BI – Power Pivot (Part 2)", "url": "https://sqlwithmanoj.com/2014/10/29/self-service-bi-by-using-power-bi-power-pivot-part-2/", "published_at": "2014-10-29T13:49:19+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417beb34d4", "title": "What is the use of SQL server table compression – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2014/09/30/what-is-the-use-of-sql-server-table-compression-msdn-tsql-forum/", "published_at": "2014-09-30T12:55:15+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417c3305b1", "title": "DB Basics – What are ACID properties of a Transaction in an RDBMS?", "url": "https://sqlwithmanoj.com/2014/09/28/db-basics-what-are-acid-properties-of-a-transaction-in-an-rdbms/", "published_at": "2014-09-28T01:30:00+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417cd87cd1", "title": "Microsoft Azure Redis Cache – General availability", "url": "https://sqlwithmanoj.com/2014/09/25/microsoft-azure-redis-cache-general-availability/", "published_at": "2014-09-25T10:29:50+00:00" }, { "id": "01a0d1d3-bae4-70c8-82f2-da417d780427", "title": "Difference between Temporary Table and Table Variable, which one is better in performance? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2014/09/15/difference-between-temporary-table-and-table-variable-which-one-is-better-in-performance-msdn-tsql-forum/", "published_at": "2014-09-15T11:53:22+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a73745778", "title": "DB Basics – What are Candidate, Primary, Composite & Super Keys and Difference between them?", "url": "https://sqlwithmanoj.com/2014/09/15/db-basics-what-are-candidate-primary-composite-super-keys-and-difference-between-them/", "published_at": "2014-09-15T01:30:56+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a73ea2911", "title": "Most effective way to write SQL Statement to Catch and Reverse errors during Query execution – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2014/09/11/most-effective-way-to-write-sql-statement-to-catch-and-reverse-errors-during-query-execution-msdn-tsql-forum/", "published_at": "2014-09-11T11:13:28+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7484308e", "title": "New Microsoft Azure Portal | Mind = Blown", "url": "https://sqlwithmanoj.com/2014/08/27/new-microsoft-azure-portal-mind-blown/", "published_at": "2014-08-27T07:26:05+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a748d4ad3", "title": "Start a Blog | Why, What, How, Where", "url": "https://sqlwithmanoj.com/2014/08/05/start-a-blog-why-what-how-where/", "published_at": "2014-08-05T16:21:58+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a753530c5", "title": "AdventureWorks 2014 Sample Database Released! – for SQL Server 2014 (Hekaton)", "url": "https://sqlwithmanoj.com/2014/08/05/adventureworks-2014-sample-database-released-for-sql-server-2014-hekaton/", "published_at": "2014-08-05T04:57:01+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a755e88b0", "title": "Self Service BI by using Power BI – Power Query (Part 1)", "url": "https://sqlwithmanoj.com/2014/07/28/self-service-bi-by-using-power-bi-power-query-part-1/", "published_at": "2014-07-28T13:58:24+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a75973622", "title": "SQL Tip – Disable or Enable all Indexes of a table at once", "url": "https://sqlwithmanoj.com/2014/07/28/sql-tip-disable-or-enable-all-indexes-of-a-table-at-once/", "published_at": "2014-07-28T01:30:25+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a767c7859", "title": "Maintaining Uniqueness with Clustered ColumnStore Index | SQL Server 2014", "url": "https://sqlwithmanoj.com/2014/07/24/maintaining-uniqueness-with-clustered-columnstore-index-sql-server-2014/", "published_at": "2014-07-24T10:46:26+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a77425ca8", "title": "Microsoft AZURE | The Cloud for Modern Business", "url": "https://sqlwithmanoj.com/2014/07/19/microsoft-azure-the-cloud-for-modern-business/", "published_at": "2014-07-19T10:10:53+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a77c703dd", "title": "Book Review – Getting Started with SQL Server 2014 Administration", "url": "https://sqlwithmanoj.com/2014/07/03/book-review-getting-started-with-sql-server-2014-administration/", "published_at": "2014-07-03T11:14:20+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a78a6292d", "title": "SQL Error – The specified ‘@notify_email_operator_name’ is invalid (valid values are returned by sp_help_operator)", "url": "https://sqlwithmanoj.com/2014/06/24/sql-error-the-specified-notify_email_operator_name-is-invalid-valid-values-are-returned-by-sp_help_operator/", "published_at": "2014-06-24T11:23:04+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a78f41352", "title": "How to convert ‘20140620’ date to ‘DD-MM-YYYY’ format – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2014/06/12/how-to-convert-20140620-date-to-dd-mm-yyyy-format-msdn-tsql-forum/", "published_at": "2014-06-12T11:04:19+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a796092f4", "title": "Identify potential free space in Database files before shrinking – TSQL Query", "url": "https://sqlwithmanoj.com/2014/04/27/identify-potential-free-space-in-database-files-before-shrinking-tsql-query/", "published_at": "2014-04-27T11:07:26+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a79722ebc", "title": "Query to check AlwaysON Replica Latency for the LSNs (Log Sequence Numbers) by using DMVs", "url": "https://sqlwithmanoj.com/2014/04/11/query-to-check-alwayson-replica-latency-for-the-lsns-log-sequence-numbers-by-using-dmvs/", "published_at": "2014-04-11T12:52:43+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7a05f2f1", "title": "Top SQL Blogs – Windows 8 App | from MSDN, MVPs and Top Bloggers", "url": "https://sqlwithmanoj.com/2014/03/14/top-sql-blogs-windows-8-app-from-msdn-mvps-and-top-bloggers/", "published_at": "2014-03-14T04:40:57+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7a5f1c95", "title": "PowerBI now GA | Intro & Resources", "url": "https://sqlwithmanoj.com/2014/03/06/powerbi-now-ga-intro-resources/", "published_at": "2014-03-06T10:28:59+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7b1c66ef", "title": "Power BI for Office 365 | Self Service BI in Excel", "url": "https://sqlwithmanoj.com/2014/03/04/power-bi-for-office-365-self-service-bi-in-excel/", "published_at": "2014-03-04T14:52:21+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7bc03ecc", "title": "Cannot use Temp Table and Table Variable in Views, why? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2014/02/14/cannot-use-temp-table-and-table-variable-in-views-why-msdn-tsql-forum/", "published_at": "2014-02-14T13:02:52+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7c084ab8", "title": "SQL Trivia – Find second (or nth) Highest Salary or Marks", "url": "https://sqlwithmanoj.com/2014/01/05/sql-trivia-find-second-or-nth-highest-salary-or-marks/", "published_at": "2014-01-05T01:30:00+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7c2094d9", "title": "2013 in review", "url": "https://sqlwithmanoj.com/2013/12/31/2013-in-review/", "published_at": "2013-12-31T06:41:33+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7d13302a", "title": "Memory Optimized Indexes | Hash vs Range Indexes – SQL Server 2014", "url": "https://sqlwithmanoj.com/2013/12/20/memory-optimized-indexes-hash-vs-range-indexes/", "published_at": "2013-12-20T11:42:53+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7d9fc0e4", "title": "XTP (eXtreme Transaction Processing) with Hekaton Tables & Native Compiled Stored Procedures – SQL Server 2014", "url": "https://sqlwithmanoj.com/2013/12/19/xtp-extreme-transaction-processing-with-hekaton-tables-stored-procedures/", "published_at": "2013-12-19T13:08:09+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7e740b19", "title": "MERGE data from source Table to target Table across Databases with a SP – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/12/18/merge-data-from-source-table-to-target-table-across-databases-with-a-sp-msdn-tsql-forum/", "published_at": "2013-12-18T12:02:27+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7f3ff591", "title": "SQL Tips – Search and list out SQL Jobs containing specific word, text or SQL Query", "url": "https://sqlwithmanoj.com/2013/12/12/sql-tips-search-and-list-out-sql-jobs-containing-specific-word-text-or-sql-query/", "published_at": "2013-12-12T12:54:45+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a7fd809f0", "title": "Preparing for 70-463 Exam : Implementing a Data Warehouse with Microsoft SQL Server 2012", "url": "https://sqlwithmanoj.com/2013/12/05/preparing-for-70-463-exam-implementing-a-data-warehouse-with-microsoft-sql-server-2012/", "published_at": "2013-12-05T10:50:17+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a80806560", "title": "SQL Server 2012 Certification Path", "url": "https://sqlwithmanoj.com/2013/11/06/sql-server-2012-certification-path/", "published_at": "2013-11-06T10:51:14+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a81497fe3", "title": "CTP-2 released for SQL Server 2014 | and I’ve installed it !", "url": "https://sqlwithmanoj.com/2013/10/16/ctp-2-released-for-sql-server-2014-and-ive-installed-it/", "published_at": "2013-10-16T08:27:54+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a820f9a9d", "title": "Difference between NOLOCK and READPAST table hints", "url": "https://sqlwithmanoj.com/2013/10/04/difference-between-nolock-and-readpast-table-hints/", "published_at": "2013-10-04T14:09:55+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a823e87ae", "title": "Behind the scenes with Hekaton Tables & Native Compiled SPs | SQL Server 2014", "url": "https://sqlwithmanoj.com/2013/09/25/behind-the-scenes-with-hekaton-tables-compiled-sps-sql-server-2014/", "published_at": "2013-09-25T12:38:45+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a82d9203d", "title": "Use new TRY_PARSE() instead of ISNUMERIC() | SQL Server 2012", "url": "https://sqlwithmanoj.com/2013/09/20/use-new-try_parse-instead-of-isnumeric-sql-server-2012/", "published_at": "2013-09-20T15:49:53+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a82fb5a20", "title": "ColumnStore Index enhancements in SQL Server 2014", "url": "https://sqlwithmanoj.com/2013/08/20/columnstore-index-enhancements-in-sql-server-2014/", "published_at": "2013-08-20T07:29:00+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a82fc4911", "title": "Getting Started with Hekaton (Memory Optimized) tables | SQL Server 2014", "url": "https://sqlwithmanoj.com/2013/07/16/getting-started-with-hekaton-tables-sql-server-2014/", "published_at": "2013-07-16T05:42:29+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a83bec509", "title": "Convert XML to Columns – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/07/13/convert-xml-to-columns-msdn-tsql-forum/", "published_at": "2013-07-13T12:40:24+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a84966f3b", "title": "Finally installed SQL Server 2014 CTP1", "url": "https://sqlwithmanoj.com/2013/07/12/finally-installed-sql-server-2014-ctp1/", "published_at": "2013-07-12T11:15:05+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a84cfe6a6", "title": "SQL Server 2014 | New Features", "url": "https://sqlwithmanoj.com/2013/07/05/sql-server-2014-new-features/", "published_at": "2013-07-05T10:17:12+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a854e9a7f", "title": "SQL DBA – Move tempDB to another drive in simple steps", "url": "https://sqlwithmanoj.com/2013/06/27/dba-move-tempdb-to-another-drive-in-simple-steps/", "published_at": "2013-06-27T05:51:08+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a85c33db2", "title": "SQL Server 2014 CTP1 now Available… download now!!!", "url": "https://sqlwithmanoj.com/2013/06/25/sql-server-2014-ctp1-now-available-download-now/", "published_at": "2013-06-25T08:39:32+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a866290e5", "title": "Excel pasting dataset in single column, copied from SSMS Results grid", "url": "https://sqlwithmanoj.com/2013/06/21/excel-pasting-dataset-in-single-column-copied-from-ssms-results-grid/", "published_at": "2013-06-21T07:48:37+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a874fca5f", "title": "Clustered Index will not always guarantee Sorted Rows", "url": "https://sqlwithmanoj.com/2013/06/10/clustered-index-will-not-always-guarantee-sorted-rows/", "published_at": "2013-06-10T11:12:09+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a88066789", "title": "Script out all SQL Jobs – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/06/06/script-out-all-sql-jobs-msdn-tsql-forum/", "published_at": "2013-06-06T15:18:20+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a881c0391", "title": "Reference a table in a Stored Procedure (SP), and call the SP from the trigger? – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/06/06/reference-a-table-in-a-stored-procedure-sp-and-call-the-sp-from-the-trigger-msdn-tsql-forum/", "published_at": "2013-06-06T11:37:12+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a890d41ae", "title": "Clustered Index do “NOT” guarantee Physically Ordering or Sorting of Rows", "url": "https://sqlwithmanoj.com/2013/06/02/clustered-index-do-not-guarantee-physically-ordering-or-sorting-of-rows/", "published_at": "2013-06-02T16:20:11+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a89e73c85", "title": "Linked Server error: Named Pipes Provider: Could not open a connection to SQL Server [53] – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/05/31/linked-server-error-named-pipes-provider-could-not-open-a-connection-to-sql-server-53-msdn-tsql-forum/", "published_at": "2013-05-31T10:37:40+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8ae62863", "title": "Informatica | Thread: WRITER_1_*_1, Message Code: WRT_8229, Native Error: 3621, Violation of PRIMARY KEY constraint", "url": "https://sqlwithmanoj.com/2013/05/30/informatica-thread-writer_1__1-message-code-wrt_8229-native-error-3621-violation-of-primary-key-constraint/", "published_at": "2013-05-30T16:06:39+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8b6f5552", "title": "SQL Error – Logical file ‘XYZ_Log2’ is not part of database ‘XYZ’. Use RESTORE FILELISTONLY to list the logical file names.", "url": "https://sqlwithmanoj.com/2013/05/12/logical-file-xyz_log2-is-not-part-of-database-xyz-use-restore-filelistonly-to-list-the-logical-file-names/", "published_at": "2013-05-12T09:11:52+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8bc5610a", "title": "Off topic | ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)", "url": "https://sqlwithmanoj.com/2013/05/07/off-topic-error-the-rpc-server-is-unavailable-exception-from-hresult-0x800706ba/", "published_at": "2013-05-06T19:51:46+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8caf6bf0", "title": "SQLwithManoj now on Windows 8 Store", "url": "https://sqlwithmanoj.com/2013/04/20/sqlwithmanoj-now-on-windows-8-store/", "published_at": "2013-04-20T08:09:45+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8d0ea69d", "title": "SQL DBA – Disable/Enable multiple SQL Jobs at once", "url": "https://sqlwithmanoj.com/2013/04/09/disableenable-multiple-sql-jobs-at-once/", "published_at": "2013-04-09T17:15:38+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8e039858", "title": "Database TRIGGER on delete – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/03/08/database-trigger-on-delete-msdn-tsql-forum/", "published_at": "2013-03-08T10:31:28+00:00" }, { "id": "01a0d1d3-f456-70b8-9094-633a8e372c14", "title": "XML to Table – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2013/02/28/xml-to-table-msdn-tsql-forum/", "published_at": "2013-02-28T10:45:59+00:00" } ] posts Claim your blog
Back to sqlwithmanoj.com
Blog · corpus.blog/blogs/sqlwithmanoj.com/posts

sqlwithmanoj.com

sqlwithmanoj.com

2015

In-memory enhancements and improvements in SQL Server 2016original ↗
14 Jun 2015
Leap Second coming this June 2015, will it affect SQL Server?original ↗
13 Jun 2015
T-SQL Query solution to ‎SSGAS2015‬ 2nd Question/Challenge – SQL Server Geeksoriginal ↗
12 Jun 2015
This blog just crossed one million hits – Thanks!!!original ↗
11 Jun 2015
ColumnStore Indexes evolution from SQL Server 2012, 2014 to 2016original ↗
8 Jun 2015
Limitations of SQL Server Express Editionoriginal ↗
7 Jun 2015
Now truncate “Table Partitions” with TRUNCATE TABLE statement – SQL Server 2016original ↗
4 Jun 2015
See Execution Plans running with Live Query Statistics – SQL Server 2016original ↗
3 Jun 2015
Enable Query Store on a Database – SQL Server 2016original ↗
2 Jun 2015
Export/Convert Table or SQL Query data to JSON string format | SQL Server 2016 – Part 1original ↗
1 Jun 2015
SQL DBA – Windows could not start the SQL Server… refer to service-specific error code 17051 – SQL Server Evaluation period has expiredoriginal ↗
31 May 2015
Query Store – new feature in SQL Server 2016original ↗
30 May 2015
Installing SQL Server 2016 CTP2 | and new features in SSMSoriginal ↗
29 May 2015
Microsoft SQL Server 2016 Public Preview (CTP2) Available – download noworiginal ↗
27 May 2015
Native JSON support – new feature in SQL Server 2016original ↗
27 May 2015
Reading XML data in SQL Server – MSDN TSQL forumoriginal ↗
26 May 2015
SQL Myth | Nested Transactions in SQL Server and hidden secretsoriginal ↗
26 May 2015
SQL error – Msg 6401, Level 16, State 1 – Cannot roll back Transaction. No transaction or savepoint of that name was foundoriginal ↗
25 May 2015
SQL Myth | Primary Key (PK) always creates Clustered Indexoriginal ↗
24 May 2015
SQL Basics – Difference between WHERE, GROUP BY and HAVING clauseoriginal ↗
23 May 2015
Getting started with SQL Server 2014 | Download and Install Free (Express) or Full versionoriginal ↗
18 May 2015
SQL Recovery utility by SysTools | easily Recover your corrupt Database in few clicksoriginal ↗
14 May 2015
Microsoft announced SQL Server 2016 – New features and enhancementsoriginal ↗
8 May 2015
What is SQL, PL/SQL, T-SQL and difference between themoriginal ↗
3 May 2015
Preparing for 70-462 Exam : Administering Microsoft SQL Server 2012 Databases | Certificationoriginal ↗
1 May 2015
SQL Error – SQLState = S0002 NativeError = 208 [SQL Server Native Client 11.0][SQL Server]Invalid object name ‘xyztable’ Unable to resolve column level collationsoriginal ↗
16 Apr 2015
DDL and DML in Single Script with GO (batch separator) – MSDN TSQL forumoriginal ↗
16 Apr 2015
Table to store MS Word docs, only be accessible via SQL Queries – MSDN TSQL forumoriginal ↗
15 Apr 2015
SQL Error – Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1 SQL Server blocked access because this component is turned offoriginal ↗
14 Apr 2015
Export XML column data to a file.xmloriginal ↗
13 Apr 2015
Error Msg 7302, Cannot create an instance of OLE DB provider “Microsoft.Jet.OLEDB.4.0” for linked server – MSDN TSQL forumoriginal ↗
10 Apr 2015
String concatenation resulting NULL values – MSDN TSQL forumoriginal ↗
9 Apr 2015
DELETE from Parent and all its child tables with Foriegn Key (no DELETE ON CASCADE) – MSDN TSQL forumoriginal ↗
8 Apr 2015
Index Usage Stats – Indexes Used, Unused and Updatedoriginal ↗
2 Apr 2015
Standardize TRY CATCH block across all Stored Procedures – MSDN TSQL forumoriginal ↗
31 Mar 2015
SQLNCLI11 for linked server “XYZ” returned message “Requested conversion is not supported” | SQL Server 2012 upgrade behavior changesoriginal ↗
27 Mar 2015
GROUPING SETS equivalent | for SQL Server 2005 and beloworiginal ↗
23 Mar 2015
Dynamic SQL usage, when to use? – MSDN TSQL forumoriginal ↗
4 Mar 2015
SQL Basics – What are Row Constructors?original ↗
16 Feb 2015
Capture multiple errors in TRY CATCH by using THROW statementoriginal ↗
4 Feb 2015
Microsoft’s upcoming USCMO Webcasts | Digital Eventsoriginal ↗
16 Jan 2015
SQL Error – Index (zero based) must be greater than or equal to zero and less than the size of argument listoriginal ↗
11 Jan 2015

2014

2014 in revieworiginal ↗
30 Dec 2014
What is ODS (Operational Data Store) and how it differs from Data Warehouse (DW)original ↗
17 Dec 2014
Using GROUPING SETS | SQL Server 2008 and aboveoriginal ↗
20 Nov 2014
Self Service BI by using Power BI – Power Pivot (Part 2)original ↗
29 Oct 2014
What is the use of SQL server table compression – MSDN TSQL forumoriginal ↗
30 Sept 2014
DB Basics – What are ACID properties of a Transaction in an RDBMS?original ↗
28 Sept 2014
Microsoft Azure Redis Cache – General availabilityoriginal ↗
25 Sept 2014
Difference between Temporary Table and Table Variable, which one is better in performance? – MSDN TSQL forumoriginal ↗
15 Sept 2014
DB Basics – What are Candidate, Primary, Composite & Super Keys and Difference between them?original ↗
15 Sept 2014
Most effective way to write SQL Statement to Catch and Reverse errors during Query execution – MSDN TSQL forumoriginal ↗
11 Sept 2014
New Microsoft Azure Portal | Mind = Blownoriginal ↗
27 Aug 2014
Start a Blog | Why, What, How, Whereoriginal ↗
5 Aug 2014
AdventureWorks 2014 Sample Database Released! – for SQL Server 2014 (Hekaton)original ↗
5 Aug 2014
Self Service BI by using Power BI – Power Query (Part 1)original ↗
28 Jul 2014
SQL Tip – Disable or Enable all Indexes of a table at onceoriginal ↗
28 Jul 2014
Maintaining Uniqueness with Clustered ColumnStore Index | SQL Server 2014original ↗
24 Jul 2014
Microsoft AZURE | The Cloud for Modern Businessoriginal ↗
19 Jul 2014
Book Review – Getting Started with SQL Server 2014 Administrationoriginal ↗
3 Jul 2014
SQL Error – The specified ‘@notify_email_operator_name’ is invalid (valid values are returned by sp_help_operator)original ↗
24 Jun 2014
How to convert ‘20140620’ date to ‘DD-MM-YYYY’ format – MSDN TSQL forumoriginal ↗
12 Jun 2014
Identify potential free space in Database files before shrinking – TSQL Queryoriginal ↗
27 Apr 2014
Query to check AlwaysON Replica Latency for the LSNs (Log Sequence Numbers) by using DMVsoriginal ↗
11 Apr 2014
Top SQL Blogs – Windows 8 App | from MSDN, MVPs and Top Bloggersoriginal ↗
14 Mar 2014
PowerBI now GA | Intro & Resourcesoriginal ↗
6 Mar 2014
Power BI for Office 365 | Self Service BI in Exceloriginal ↗
4 Mar 2014
Cannot use Temp Table and Table Variable in Views, why? – MSDN TSQL forumoriginal ↗
14 Feb 2014
SQL Trivia – Find second (or nth) Highest Salary or Marksoriginal ↗
5 Jan 2014

2013

2013 in revieworiginal ↗
31 Dec 2013
Memory Optimized Indexes | Hash vs Range Indexes – SQL Server 2014original ↗
20 Dec 2013
XTP (eXtreme Transaction Processing) with Hekaton Tables & Native Compiled Stored Procedures – SQL Server 2014original ↗
19 Dec 2013
MERGE data from source Table to target Table across Databases with a SP – MSDN TSQL forumoriginal ↗
18 Dec 2013
SQL Tips – Search and list out SQL Jobs containing specific word, text or SQL Queryoriginal ↗
12 Dec 2013
Preparing for 70-463 Exam : Implementing a Data Warehouse with Microsoft SQL Server 2012original ↗
5 Dec 2013
SQL Server 2012 Certification Pathoriginal ↗
6 Nov 2013
CTP-2 released for SQL Server 2014 | and I’ve installed it !original ↗
16 Oct 2013
Difference between NOLOCK and READPAST table hintsoriginal ↗
4 Oct 2013
Behind the scenes with Hekaton Tables & Native Compiled SPs | SQL Server 2014original ↗
25 Sept 2013
Use new TRY_PARSE() instead of ISNUMERIC() | SQL Server 2012original ↗
20 Sept 2013
ColumnStore Index enhancements in SQL Server 2014original ↗
20 Aug 2013
Getting Started with Hekaton (Memory Optimized) tables | SQL Server 2014original ↗
16 Jul 2013
Convert XML to Columns – MSDN TSQL forumoriginal ↗
13 Jul 2013
Finally installed SQL Server 2014 CTP1original ↗
12 Jul 2013
SQL Server 2014 | New Featuresoriginal ↗
5 Jul 2013
SQL DBA – Move tempDB to another drive in simple stepsoriginal ↗
27 Jun 2013
SQL Server 2014 CTP1 now Available… download now!!!original ↗
25 Jun 2013
Excel pasting dataset in single column, copied from SSMS Results gridoriginal ↗
21 Jun 2013
Clustered Index will not always guarantee Sorted Rowsoriginal ↗
10 Jun 2013
Script out all SQL Jobs – MSDN TSQL forumoriginal ↗
6 Jun 2013
Reference a table in a Stored Procedure (SP), and call the SP from the trigger? – MSDN TSQL forumoriginal ↗
6 Jun 2013
Clustered Index do “NOT” guarantee Physically Ordering or Sorting of Rowsoriginal ↗
2 Jun 2013
Linked Server error: Named Pipes Provider: Could not open a connection to SQL Server [53] – MSDN TSQL forumoriginal ↗
31 May 2013
Informatica | Thread: WRITER_1_*_1, Message Code: WRT_8229, Native Error: 3621, Violation of PRIMARY KEY constraintoriginal ↗
30 May 2013
SQL Error – Logical file ‘XYZ_Log2’ is not part of database ‘XYZ’. Use RESTORE FILELISTONLY to list the logical file names.original ↗
12 May 2013
Off topic | ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)original ↗
6 May 2013
SQLwithManoj now on Windows 8 Storeoriginal ↗
20 Apr 2013
SQL DBA – Disable/Enable multiple SQL Jobs at onceoriginal ↗
9 Apr 2013
Database TRIGGER on delete – MSDN TSQL forumoriginal ↗
8 Mar 2013
XML to Table – MSDN TSQL forumoriginal ↗
28 Feb 2013
Previous Next