corpus.blog
56,966 blogs · [ { "id": "01a0d1d4-23d7-730f-9147-bf819861d356", "title": "SET STATISTICS IO and TIME – What are Logical, Physical and Read-Ahead Reads?", "url": "https://sqlwithmanoj.com/2013/02/20/set-statistics-io-and-time-what-are-logical-physical-and-read-ahead-reads/", "published_at": "2013-02-20T10:52:45+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81987d43cc", "title": "SET STATISTICS IO – What is Scan count?", "url": "https://sqlwithmanoj.com/2013/02/16/set-statistics-io-what-is-scan-count/", "published_at": "2013-02-16T04:29:49+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf8198d8fb73", "title": "Another reason to use THROW clause instead of RAISERROR | SQL Server 2012", "url": "https://sqlwithmanoj.com/2013/01/24/another-reason-to-use-throw-clause-instead-of-raiserror-sql-server-2012/", "published_at": "2013-01-24T13:03:44+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819962362e", "title": "Enhanced OVER() Clause in SQL Server 2012 – Part2", "url": "https://sqlwithmanoj.com/2013/01/02/enhanced-over-clause-in-sql-server-2012-part2-2/", "published_at": "2013-01-02T04:53:02+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf8199b8b810", "title": "2012 in review", "url": "https://sqlwithmanoj.com/2012/12/31/2012-in-review/", "published_at": "2012-12-31T04:37:29+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819a2cadbe", "title": "Using FullText search with FileTables in SQL Server 2012", "url": "https://sqlwithmanoj.com/2012/12/21/using-fulltext-search-with-filetables-in-sql-server-2012/", "published_at": "2012-12-21T11:14:16+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819a8b0450", "title": "New THROW statement in SQL Server 2012 (vs RAISERROR)", "url": "https://sqlwithmanoj.com/2012/12/20/new-throw-statement-in-sql-server-2012-vs-raiserror/", "published_at": "2012-12-20T13:37:12+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819aacdd36", "title": "SQL DBA – Move user Database (.mdf & .ldf files) to another drive", "url": "https://sqlwithmanoj.com/2012/12/17/sql-basics-move-use-database-mdf-ldf-files-to-another-drive/", "published_at": "2012-12-17T18:26:19+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819b8fecf9", "title": "SQL DBA – When was the Database restored (Query)?", "url": "https://sqlwithmanoj.com/2012/12/13/sql-dba-when-was-the-database-restored-query/", "published_at": "2012-12-13T04:53:12+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819bfded34", "title": "SQL Server 2012 does not support Linked Server to SQL Server 2000, workaround", "url": "https://sqlwithmanoj.com/2012/12/10/sql-server-2012-does-not-support-linked-server-to-sql-server-2000-workaround/", "published_at": "2012-12-10T09:26:37+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819cc31530", "title": "SQL Server vNext (2012) coming up with lot a new features | Hekaton, Polybase, PDW, and many more", "url": "https://sqlwithmanoj.com/2012/11/27/sql-server-vnext-coming-up-with-lot-a-new-features-hekaton-polybase-pdw-and-many-more/", "published_at": "2012-11-27T16:51:33+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819d1af8e1", "title": "SQL Server 2012 | Temp Tables are created with negative Object IDs", "url": "https://sqlwithmanoj.com/2012/11/19/sql-server-2012-temp-tables-are-created-with-negative-object-ids/", "published_at": "2012-11-19T16:55:11+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819d1bea7b", "title": "Passed 70-461 Exam : Querying Microsoft SQL Server 2012", "url": "https://sqlwithmanoj.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/", "published_at": "2012-11-16T16:03:54+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819df73829", "title": "SQL DBA – Moved MASTER database by ALTER DATABASE statement? here’s the solution", "url": "https://sqlwithmanoj.com/2012/10/08/moved-master-database-by-alter-database-statement-heres-the-solution/", "published_at": "2012-10-08T15:53:47+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819e5f8907", "title": "SQL Tips – Different ways to get SQL Server Version", "url": "https://sqlwithmanoj.com/2012/10/05/different-ways-to-get-sql-server-version/", "published_at": "2012-10-05T12:14:56+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819ec1d83b", "title": "Security Compliance Manager (SCM) 3.0 now available for beta download!", "url": "https://sqlwithmanoj.com/2012/10/04/security-compliance-manager-scm-3-0-now-available-for-beta-download/", "published_at": "2012-10-04T09:33:34+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819f14eecc", "title": "Passing multiple/dynamic values to Stored Procedures & Functions | Part 4 – by using TVP", "url": "https://sqlwithmanoj.com/2012/09/10/passing-multipledynamic-values-to-stored-procedures-functions-part4-by-using-tvp/", "published_at": "2012-09-10T18:07:39+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819f1f5f54", "title": "Passing multiple/dynamic values to Stored Procedures & Functions | Part 3 – by using #table", "url": "https://sqlwithmanoj.com/2012/09/09/passing-multipledynamic-values-to-stored-procedures-functions-part3-by-using-table/", "published_at": "2012-09-09T13:31:19+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819f263af5", "title": "Passing multiple/dynamic values to Stored Procedures & Functions | Part 2 – by passing XML", "url": "https://sqlwithmanoj.com/2012/09/09/passing-multipledynamic-values-to-stored-procedures-functions-part2-by-passing-xml/", "published_at": "2012-09-09T13:02:33+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf819fbaca0c", "title": "Passing multiple/dynamic values to Stored Procedures & Functions | Part 1 – by passing CSV", "url": "https://sqlwithmanoj.com/2012/09/09/passing-multipledynamic-values-to-stored-procedures-functions-part1-by-passing-csv/", "published_at": "2012-09-09T09:19:12+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a08fac2d", "title": "SQL DBA – Upgrade to SQL Server 2012 – Use Upgrade Advisor", "url": "https://sqlwithmanoj.com/2012/09/02/upgrade-to-sql-server-2012-use-upgrade-advisor/", "published_at": "2012-09-02T09:17:50+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a15038c8", "title": "Columnstore Indexes in SQL Server 2012", "url": "https://sqlwithmanoj.com/2012/08/11/columnstore-indexes-in-sql-server-2012/", "published_at": "2012-08-11T01:30:58+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a1edc099", "title": "New CHOOSE() and IIF() functions introduced in SQL Server 2012 (Denali)", "url": "https://sqlwithmanoj.com/2012/08/06/new-choose-and-iif-functions-introduced-in-sql-server-2012-denali/", "published_at": "2012-08-06T17:08:48+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a2463337", "title": "Search a String in Stored Procedure, View, Function or other database object definitions", "url": "https://sqlwithmanoj.com/2012/08/01/search-a-string-in-stored-procedure-view-function-or-other-database-object-definitions/", "published_at": "2012-08-01T17:16:35+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a2933686", "title": "“Identity Gap” Issue with the new SEQUENCE feature in SQL Server 2012 … and its workaround", "url": "https://sqlwithmanoj.com/2012/07/27/issue-with-the-new-sequence-feature-in-sql-server-2012-and-its-workaround/", "published_at": "2012-07-27T14:10:28+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a2c3708d", "title": "Jump/Gap Issue with IDENTITY property in SQL Server 2012 … and its workaround (not a bug)", "url": "https://sqlwithmanoj.com/2012/07/27/issue-with-identity-property-in-sql-server-2012-and-its-workaround/", "published_at": "2012-07-27T07:11:18+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a2f86dae", "title": "Reorganize Index vs Rebuild Index in SQL Server", "url": "https://sqlwithmanoj.com/2012/07/25/reorganize-index-vs-rebuild-index/", "published_at": "2012-07-25T11:39:21+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a2fd5a3a", "title": "Microsoft Assessment and Planning (MAP) Toolkit 7.0 now available | Accelerate your migration to the private cloud", "url": "https://sqlwithmanoj.com/2012/07/12/microsoft-assessment-and-planning-map-toolkit-7-0-now-available-accelerate-your-migration-to-the-private-cloud/", "published_at": "2012-07-11T18:50:09+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a37dbb71", "title": "Querying Excel 2010 from SQL Server in 64-bit environment", "url": "https://sqlwithmanoj.com/2012/07/10/querying-excel-2010-from-sql-server-in-64-bit-environment/", "published_at": "2012-07-10T12:05:00+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a44a4a25", "title": "Difference between Decimal and Numeric datatypes", "url": "https://sqlwithmanoj.com/2012/06/08/difference-between-decimal-and-numeric-datatypes/", "published_at": "2012-06-08T10:24:00+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a4d8eca1", "title": "SQL Server 2012 Upgrade Technical Guide and Why Upgrade", "url": "https://sqlwithmanoj.com/2012/05/16/sql-server-2012-upgrade-technical-guide-and-why-upgrade/", "published_at": "2012-05-16T05:32:39+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a5142350", "title": "SQL Server 2012 (a.k.a Denali) – New Functions: CONCAT & FORMAT", "url": "https://sqlwithmanoj.com/2012/05/09/sql-server-2012-a-k-a-denali-new-functions-concat-format/", "published_at": "2012-05-09T12:49:03+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a5577a30", "title": "GO is not a valid TSQL statement", "url": "https://sqlwithmanoj.com/2012/05/06/go-is-not-a-valid-tsql-statement/", "published_at": "2012-05-06T11:02:43+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a5f79eac", "title": "All about IDENTITY columns in SQL Server", "url": "https://sqlwithmanoj.com/2012/05/03/all-about-identity-columns/", "published_at": "2012-05-03T12:19:09+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a6da862d", "title": "SQL Server 2012 (a.k.a. Denali) | The Fantastic 12 of 2012", "url": "https://sqlwithmanoj.com/2012/04/24/sql-server-2012-a-k-a-denali-the-fantastic-12-of-2012/", "published_at": "2012-04-24T05:33:22+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a76aaa22", "title": "SQL Server 2012 (a.k.a. Denali) – Best Practices Analyzer", "url": "https://sqlwithmanoj.com/2012/04/23/sql-server-2012-a-k-a-denali-best-practices-analyzer/", "published_at": "2012-04-23T06:01:52+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a781ebcb", "title": "SQL DBA – Check Isolation Level of a Database | DBCC USEROPTIONS", "url": "https://sqlwithmanoj.com/2012/04/20/check-isolation-level-of-a-database-dbcc-useroptions/", "published_at": "2012-04-20T09:28:07+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a87cde70", "title": "Microsoft Deployment Toolkit (MDT) 2012 Now Available | Reliable and flexible OS deployment", "url": "https://sqlwithmanoj.com/2012/04/18/microsoft-deployment-toolkit-mdt-2012-now-available-reliable-and-flexible-os-deployment/", "published_at": "2012-04-18T04:42:54+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a9603bd6", "title": "SQL Server 2012 (a.k.a. Denali) | “SET FMTONLY ON/OFF” Deprecated | new SPs and DMFs Introduced", "url": "https://sqlwithmanoj.com/2012/04/17/sql-server-2012-a-k-a-denali-set-fmtonly-onoff-deprecated-new-sps-and-dmfs-introduced/", "published_at": "2012-04-17T05:43:56+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81a9ca2ce0", "title": "SQL Server 2012 (a.k.a Denali) – New feature | Enhanced OVER() Clause – Part1", "url": "https://sqlwithmanoj.com/2012/04/13/sql-server-2012-a-k-a-denali-new-feature-enhanced-over-clause-part1/", "published_at": "2012-04-13T08:08:09+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81aa292b11", "title": "SQL Server 2012 (a.k.a Denali) – New feature | WITH RESULT SETS", "url": "https://sqlwithmanoj.com/2012/04/12/sql-server-2012-a-k-a-denali-new-feature-with-result-sets/", "published_at": "2012-04-12T12:51:03+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81aa9fb1b4", "title": "‘NOCHECK’ vs ‘WITH NOCHECK’… while creating disabled Foreign Key (FK) constraint", "url": "https://sqlwithmanoj.com/2012/03/14/nocheck-vs-with-nocheck-while-creating-disabled-foreign-key-fk-constraint/", "published_at": "2012-03-14T08:29:12+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81ab142fff", "title": "SQL Server 2012 (a.k.a Denali) – New feature | FileTables", "url": "https://sqlwithmanoj.com/2012/02/28/sql-server-2012-a-k-a-denali-new-feature-filetables/", "published_at": "2012-02-28T13:55:59+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81abc59a68", "title": "Best Practices while creating Stored Procedures", "url": "https://sqlwithmanoj.com/2012/02/26/best-practices-while-creating-stored-procedures/", "published_at": "2012-02-26T07:29:17+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81abfb79d6", "title": "manub22 (me) on MCC 2011 awardee list", "url": "https://sqlwithmanoj.com/2012/01/10/manub22-me-on-mcc-2011-awardee-list/", "published_at": "2012-01-10T05:58:37+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81accf8210", "title": "Using CROSS APPLY & OUTER APPLY operators with UDFs, Derived tables & XML data", "url": "https://sqlwithmanoj.com/2012/01/03/using-cross-apply-outer-apply-operators-with-udfs-derived-tables-xml-data/", "published_at": "2012-01-03T09:30:40+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81ada7bdb3", "title": "2011 in review", "url": "https://sqlwithmanoj.com/2012/01/01/2011-in-review/", "published_at": "2012-01-01T05:31:34+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81ade87af9", "title": "Creating Stored Procedure with Dynamic Search, Paging and Sorting", "url": "https://sqlwithmanoj.com/2011/12/30/creating-stored-procedure-with-dynamic-search-paging-and-sorting/", "published_at": "2011-12-30T12:07:44+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81adf0a16f", "title": "Creating Stored Procedures with Dynamic Search & Paging (Pagination)", "url": "https://sqlwithmanoj.com/2011/12/30/creating-stored-procedures-with-dynamic-search-paging-pagination/", "published_at": "2011-12-30T10:07:11+00:00" }, { "id": "01a0d1d4-23d7-730f-9147-bf81ae3e8695", "title": "Creating Stored Procedures with Dynamic Search (filter)", "url": "https://sqlwithmanoj.com/2011/12/30/creating-stored-procedures-with-dynamic-search-filter/", "published_at": "2011-12-30T05:54:23+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b7996fc2812", "title": "Recursive CTE error – The maximum recursion 100 has been exhausted before statement completion", "url": "https://sqlwithmanoj.com/2011/12/23/recursive-cte-maximum-recursion-100-has-been-exhausted/", "published_at": "2011-12-23T07:26:32+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b7997150c9f", "title": "MSDN & Online Technical Articles on using XML with SQL", "url": "https://sqlwithmanoj.com/2011/12/22/msdn-online-technical-articles-on-using-xml-with-sql/", "published_at": "2011-12-22T19:38:44+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799732f6d4", "title": "Using IDENTITY function with SELECT statement in SQL Server", "url": "https://sqlwithmanoj.com/2011/12/15/using-identity-function-with-select-statement/", "published_at": "2011-12-15T06:00:37+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79979cf1d5", "title": "Query XML with different languages or different UNICODE encodings [UTF-8 & UTF-16]", "url": "https://sqlwithmanoj.com/2011/12/09/query-xml-with-different-languages-or-different-unicode-encodings-utf-8-utf-16/", "published_at": "2011-12-09T08:06:32+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b7997d30a99", "title": "TSQL Interview Questions – Part 5", "url": "https://sqlwithmanoj.com/2011/12/06/tsql-interview-questions-part-5/", "published_at": "2011-12-06T19:05:12+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b7998d1eb15", "title": "SQL Server’s weird behavior in error handling with transactions", "url": "https://sqlwithmanoj.com/2011/12/06/sql-servers-weird-behavior-in-error-handling-with-transactions/", "published_at": "2011-12-06T12:22:51+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79992b08df", "title": "T-SQL Query for SORTing Numbers stored as String (VARCHAR)", "url": "https://sqlwithmanoj.com/2011/12/06/sorting-numbers-stored-as-string-varchar/", "published_at": "2011-12-06T06:11:52+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b7999e0203e", "title": "SQL Basics – Working with VIEWs in SQL Server", "url": "https://sqlwithmanoj.com/2011/12/02/sql-basics-working-with-views-in-sql-server/", "published_at": "2011-12-02T17:33:11+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799a5dd024", "title": "XACT_ABORT with TRANSACTIONS in SQL Server", "url": "https://sqlwithmanoj.com/2011/12/01/xact_abort-with-transactions/", "published_at": "2011-12-01T07:25:47+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799a6a3c68", "title": "Adding Namespaces in XML | Querying XML with Namespaces (SQL Server)", "url": "https://sqlwithmanoj.com/2011/11/02/adding-namespaces-in-xml-querying-xml-with-namespaces/", "published_at": "2011-11-02T06:45:26+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799ab13082", "title": "Using DML with XML – UPDATE & DELETE (SQL Server)", "url": "https://sqlwithmanoj.com/2011/10/31/using-dml-with-xml-update-delete/", "published_at": "2011-10-31T12:37:44+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799afba60f", "title": "Save XML in a file | Read XML from a file (in SQL Server)", "url": "https://sqlwithmanoj.com/2011/10/20/save-xml-in-a-file-read-xml-from-a-file/", "published_at": "2011-10-20T07:45:12+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799bc9e3bd", "title": "Using DMLs with XMLs – INSERT (SQL Server)", "url": "https://sqlwithmanoj.com/2011/10/17/using-dml-with-xml-insert/", "published_at": "2011-10-17T11:18:08+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799caa9a27", "title": "SQL Trivia – Identify & Delete Duplicate records from a table", "url": "https://sqlwithmanoj.com/2011/10/14/identify-delete-duplicate-records-from-a-table/", "published_at": "2011-10-14T05:36:01+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799d997649", "title": "What are Records, Pages, Extents, Heap in SQL Server?", "url": "https://sqlwithmanoj.com/2011/10/12/what-are-records-pages-extents-heap/", "published_at": "2011-10-12T11:27:55+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799e5e828e", "title": "UPDATE statement with new .WRITE Clause – SQL Server", "url": "https://sqlwithmanoj.com/2011/10/04/update-statement-with-new-write-clause/", "published_at": "2011-10-04T06:37:58+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b799f32fd27", "title": "more examples on querying XML …with CROSS APPLY & XQuery – in SQL Server", "url": "https://sqlwithmanoj.com/2011/09/22/more-examples-on-querying-xml-with-cross-apply-xquery/", "published_at": "2011-09-22T06:36:12+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a01c1e05", "title": "Stored Procedures vs Functions (Difference between SP & UDF) – SQL Server", "url": "https://sqlwithmanoj.com/2011/09/21/stored-procedures-vs-functions-difference-between-sp-udf/", "published_at": "2011-09-21T06:33:59+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a1141c61", "title": "BCP { IN | OUT | QUERYOUT } – the BCP util in SQL Server", "url": "https://sqlwithmanoj.com/2011/09/09/bcp-in-out-queryout-the-bcp-util/", "published_at": "2011-09-09T11:26:01+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a205df03", "title": "SQL Trivia – Reverse a string without using T-SQL REVERSE() function", "url": "https://sqlwithmanoj.com/2011/08/18/reverse-a-string-without-using-tsqls-reverse-function/", "published_at": "2011-08-18T13:19:49+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a2d6cced", "title": "SQL Server 2012 (DENALI) TSQL – New Feature in SSMS – Surround With", "url": "https://sqlwithmanoj.com/2011/08/05/denali-tsql-new-feature-ssms-surround-with/", "published_at": "2011-08-05T10:08:42+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a32eb1b0", "title": "SQL Server 2012 (DENALI) TSQL – New feature | OFFSET FETCH Clause (for paging/pagination)", "url": "https://sqlwithmanoj.com/2011/07/28/tsql-denali-new-feature-offset-fetch-clause-for-pagingpagination/", "published_at": "2011-07-28T13:23:08+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a376df21", "title": "SQL Server 2012 (DENALI) TSQL – New features | Built-in Functions", "url": "https://sqlwithmanoj.com/2011/07/27/denali-tsql-new-features-built-in-functions/", "published_at": "2011-07-27T08:47:32+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a44c4523", "title": "DB Basics – Is SELECT a DML (Data Manipulation Language)?", "url": "https://sqlwithmanoj.com/2011/07/26/dml-is-select-a-dml/", "published_at": "2011-07-26T12:44:10+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a4629163", "title": "SQL Server 2012 (DENALI) TSQL – New Feature | SEQUENCES", "url": "https://sqlwithmanoj.com/2011/07/26/denali-tsql-new-feature-sequences/", "published_at": "2011-07-26T07:08:30+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a49e5ed8", "title": "DIRTY reads and PHANTOM reads – SQL Server", "url": "https://sqlwithmanoj.com/2011/07/20/dirty-reads-and-phantom-reads/", "published_at": "2011-07-20T11:27:24+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a58a8ac8", "title": "SELECT or Query nodes in hierarchial or nested XML", "url": "https://sqlwithmanoj.com/2011/07/13/select-or-query-nodes-in-hierarchial-or-nested-xml/", "published_at": "2011-07-13T14:36:29+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a64f4886", "title": "Query XML string in tabular format – SQL Server", "url": "https://sqlwithmanoj.com/2011/07/13/query-xml-string-in-tabular-format/", "published_at": "2011-07-13T13:16:44+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a6ab7eae", "title": "Check and ReSeed IDENTITY column value in a table", "url": "https://sqlwithmanoj.com/2011/07/08/reseed-tables-identity-column-value/", "published_at": "2011-07-08T13:25:02+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a725ae75", "title": "Programming is like a Dream… by Lisa", "url": "https://sqlwithmanoj.com/2011/07/05/programming-is-like-a-dream-by-lisa/", "published_at": "2011-07-05T07:08:22+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a825392d", "title": "SQL Query for calculating Running Totals", "url": "https://sqlwithmanoj.com/2011/07/04/calculating-running-totals/", "published_at": "2011-07-04T09:58:47+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a8c4147c", "title": "SQL DBA – SHRINK DATABASE & SHRINK FILE – SQL Server", "url": "https://sqlwithmanoj.com/2011/07/02/shrink-database-shrink-file/", "published_at": "2011-07-02T05:26:02+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a8f228d9", "title": "TSQL Interview Questions – Part 4", "url": "https://sqlwithmanoj.com/2011/07/01/tsql-interview-questions-part-4/", "published_at": "2011-07-01T10:17:37+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a9ab7a43", "title": "Are User Defined Functions (UDF) pre-compiled – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2011/06/15/are-user-defined-functions-udf-pre-compiled-msdn-tsql-forum/", "published_at": "2011-06-15T12:32:42+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79a9fac652", "title": "Logging in SSIS… using SQL Server Log Provider", "url": "https://sqlwithmanoj.com/2011/06/15/logging-in-ssis-using-sql-server-log-provider/", "published_at": "2011-06-15T10:45:28+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79aa22b326", "title": "SQL DBA – DBID 32767 | Resource Database", "url": "https://sqlwithmanoj.com/2011/06/03/dbid-32767-resource-database/", "published_at": "2011-06-03T19:37:38+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79aa86f2a3", "title": "CTE Recursion | Sequence, Dates, Factorial, Fibonacci series", "url": "https://sqlwithmanoj.com/2011/05/23/cte-recursion-sequence-dates-factorial-fibonacci-series/", "published_at": "2011-05-23T12:38:26+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79aaa31182", "title": "SQL Error – Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS…", "url": "https://sqlwithmanoj.com/2011/05/20/heterogeneous-queries-require-the-ansi_nulls-and-ansi_warnings/", "published_at": "2011-05-20T07:53:21+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79ab9c73f6", "title": "Database Schema diff", "url": "https://sqlwithmanoj.com/2011/05/16/database-schema-diff/", "published_at": "2011-05-16T05:02:16+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79ac40a6cf", "title": "Select multiple number of OrderIDs and send the criteria to a Stored Procedure parameter – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2011/04/21/select-multiple-number-of-orderids-and-send-the-criteria-to-a-stored-procedure-parameter-msdn-tsql-forum/", "published_at": "2011-04-21T11:54:20+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79ad323e35", "title": "Error while Querying Excel file – The Microsoft Access database engine could not find the object ‘Sheet1$’ – MSDN TSQL Forum", "url": "https://sqlwithmanoj.com/2011/04/14/error-while-querying-excel-file-the-microsoft-access-database-engine-could-not-find-the-object-sheet1-msdn-tsql-forum/", "published_at": "2011-04-14T14:19:04+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79adb2ec34", "title": "SQL Basics – Working with NOT NULL, DEFAULT and CHECK Constraints (Domain Integrity)", "url": "https://sqlwithmanoj.com/2011/04/11/sql-basics-working-with-not-null-default-and-check-constraints-domain-integrity/", "published_at": "2011-04-11T09:31:28+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79adf9c9e8", "title": "more on – ORDER BY with CASE", "url": "https://sqlwithmanoj.com/2011/04/09/more-on-order-by-with-case/", "published_at": "2011-04-09T08:24:07+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79aec21e5b", "title": "Autocommit Transactions with SQL Server – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2011/04/07/autocommit-transactions-with-sql-server-msdn-tsql-forum/", "published_at": "2011-04-07T13:04:55+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79af925e20", "title": "How to retrieve last 12 months records form a table – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2011/03/24/how-to-retrieve-last-12-months-records-form-a-table-msdn-tsql-forum/", "published_at": "2011-03-24T13:31:02+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79b03480c1", "title": "Using OUTPUT Parameters in Stored Procedures", "url": "https://sqlwithmanoj.com/2011/03/23/using-output-parameters-in-stored-procedures/", "published_at": "2011-03-23T12:19:45+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79b0d6c277", "title": "EXECUTE (or EXEC) vs sp_executesql", "url": "https://sqlwithmanoj.com/2011/03/22/execute-or-exec-vs-sp_executesql/", "published_at": "2011-03-22T11:41:57+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79b13f78c9", "title": "Is WITH (READPAST) affected by readlocks – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2011/03/19/is-with-readpast-affected-by-readlocks-msdn-tsql-forum-2/", "published_at": "2011-03-19T11:17:47+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79b15bc9b3", "title": "Convert unicode Characters to be displayed in ASCII format – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2011/03/18/convert-unicode-characters-to-be-displayed-in-ascii-format-msdn-tsql-forum/", "published_at": "2011-03-18T11:24:57+00:00" }, { "id": "01a0d1d4-58d5-7343-bfca-9b79b1e495d7", "title": "SQL DBA – SQL Queries Executed, Running & Blocking", "url": "https://sqlwithmanoj.com/2011/03/11/sql-queries-executed-running-blocking/", "published_at": "2011-03-11T13:02:29+00:00" } ] posts Claim your blog
Back to sqlwithmanoj.com
Blog · corpus.blog/blogs/sqlwithmanoj.com/posts

sqlwithmanoj.com

sqlwithmanoj.com

2013

SET STATISTICS IO and TIME – What are Logical, Physical and Read-Ahead Reads?original ↗
20 Feb 2013
SET STATISTICS IO – What is Scan count?original ↗
16 Feb 2013
Another reason to use THROW clause instead of RAISERROR | SQL Server 2012original ↗
24 Jan 2013
Enhanced OVER() Clause in SQL Server 2012 – Part2original ↗
2 Jan 2013

2012

2012 in revieworiginal ↗
31 Dec 2012
Using FullText search with FileTables in SQL Server 2012original ↗
21 Dec 2012
New THROW statement in SQL Server 2012 (vs RAISERROR)original ↗
20 Dec 2012
SQL DBA – Move user Database (.mdf & .ldf files) to another driveoriginal ↗
17 Dec 2012
SQL DBA – When was the Database restored (Query)?original ↗
13 Dec 2012
SQL Server 2012 does not support Linked Server to SQL Server 2000, workaroundoriginal ↗
10 Dec 2012
SQL Server vNext (2012) coming up with lot a new features | Hekaton, Polybase, PDW, and many moreoriginal ↗
27 Nov 2012
SQL Server 2012 | Temp Tables are created with negative Object IDsoriginal ↗
19 Nov 2012
Passed 70-461 Exam : Querying Microsoft SQL Server 2012original ↗
16 Nov 2012
SQL DBA – Moved MASTER database by ALTER DATABASE statement? here’s the solutionoriginal ↗
8 Oct 2012
SQL Tips – Different ways to get SQL Server Versionoriginal ↗
5 Oct 2012
Security Compliance Manager (SCM) 3.0 now available for beta download!original ↗
4 Oct 2012
Passing multiple/dynamic values to Stored Procedures & Functions | Part 4 – by using TVPoriginal ↗
10 Sept 2012
Passing multiple/dynamic values to Stored Procedures & Functions | Part 3 – by using #tableoriginal ↗
9 Sept 2012
Passing multiple/dynamic values to Stored Procedures & Functions | Part 2 – by passing XMLoriginal ↗
9 Sept 2012
Passing multiple/dynamic values to Stored Procedures & Functions | Part 1 – by passing CSVoriginal ↗
9 Sept 2012
SQL DBA – Upgrade to SQL Server 2012 – Use Upgrade Advisororiginal ↗
2 Sept 2012
Columnstore Indexes in SQL Server 2012original ↗
11 Aug 2012
New CHOOSE() and IIF() functions introduced in SQL Server 2012 (Denali)original ↗
6 Aug 2012
Search a String in Stored Procedure, View, Function or other database object definitionsoriginal ↗
1 Aug 2012
“Identity Gap” Issue with the new SEQUENCE feature in SQL Server 2012 … and its workaroundoriginal ↗
27 Jul 2012
Jump/Gap Issue with IDENTITY property in SQL Server 2012 … and its workaround (not a bug)original ↗
27 Jul 2012
Reorganize Index vs Rebuild Index in SQL Serveroriginal ↗
25 Jul 2012
Microsoft Assessment and Planning (MAP) Toolkit 7.0 now available | Accelerate your migration to the private cloudoriginal ↗
11 Jul 2012
Querying Excel 2010 from SQL Server in 64-bit environmentoriginal ↗
10 Jul 2012
Difference between Decimal and Numeric datatypesoriginal ↗
8 Jun 2012
SQL Server 2012 Upgrade Technical Guide and Why Upgradeoriginal ↗
16 May 2012
SQL Server 2012 (a.k.a Denali) – New Functions: CONCAT & FORMAToriginal ↗
9 May 2012
GO is not a valid TSQL statementoriginal ↗
6 May 2012
All about IDENTITY columns in SQL Serveroriginal ↗
3 May 2012
SQL Server 2012 (a.k.a. Denali) | The Fantastic 12 of 2012original ↗
24 Apr 2012
SQL Server 2012 (a.k.a. Denali) – Best Practices Analyzeroriginal ↗
23 Apr 2012
SQL DBA – Check Isolation Level of a Database | DBCC USEROPTIONSoriginal ↗
20 Apr 2012
Microsoft Deployment Toolkit (MDT) 2012 Now Available | Reliable and flexible OS deploymentoriginal ↗
18 Apr 2012
SQL Server 2012 (a.k.a. Denali) | “SET FMTONLY ON/OFF” Deprecated | new SPs and DMFs Introducedoriginal ↗
17 Apr 2012
SQL Server 2012 (a.k.a Denali) – New feature | Enhanced OVER() Clause – Part1original ↗
13 Apr 2012
SQL Server 2012 (a.k.a Denali) – New feature | WITH RESULT SETSoriginal ↗
12 Apr 2012
‘NOCHECK’ vs ‘WITH NOCHECK’… while creating disabled Foreign Key (FK) constraintoriginal ↗
14 Mar 2012
SQL Server 2012 (a.k.a Denali) – New feature | FileTablesoriginal ↗
28 Feb 2012
Best Practices while creating Stored Proceduresoriginal ↗
26 Feb 2012
manub22 (me) on MCC 2011 awardee listoriginal ↗
10 Jan 2012
Using CROSS APPLY & OUTER APPLY operators with UDFs, Derived tables & XML dataoriginal ↗
3 Jan 2012
2011 in revieworiginal ↗
1 Jan 2012

2011

Creating Stored Procedure with Dynamic Search, Paging and Sortingoriginal ↗
30 Dec 2011
Creating Stored Procedures with Dynamic Search & Paging (Pagination)original ↗
30 Dec 2011
Creating Stored Procedures with Dynamic Search (filter)original ↗
30 Dec 2011
Recursive CTE error – The maximum recursion 100 has been exhausted before statement completionoriginal ↗
23 Dec 2011
MSDN & Online Technical Articles on using XML with SQLoriginal ↗
22 Dec 2011
Using IDENTITY function with SELECT statement in SQL Serveroriginal ↗
15 Dec 2011
Query XML with different languages or different UNICODE encodings [UTF-8 & UTF-16]original ↗
9 Dec 2011
TSQL Interview Questions – Part 5original ↗
6 Dec 2011
SQL Server’s weird behavior in error handling with transactionsoriginal ↗
6 Dec 2011
T-SQL Query for SORTing Numbers stored as String (VARCHAR)original ↗
6 Dec 2011
SQL Basics – Working with VIEWs in SQL Serveroriginal ↗
2 Dec 2011
XACT_ABORT with TRANSACTIONS in SQL Serveroriginal ↗
1 Dec 2011
Adding Namespaces in XML | Querying XML with Namespaces (SQL Server)original ↗
2 Nov 2011
Using DML with XML – UPDATE & DELETE (SQL Server)original ↗
31 Oct 2011
Save XML in a file | Read XML from a file (in SQL Server)original ↗
20 Oct 2011
Using DMLs with XMLs – INSERT (SQL Server)original ↗
17 Oct 2011
SQL Trivia – Identify & Delete Duplicate records from a tableoriginal ↗
14 Oct 2011
What are Records, Pages, Extents, Heap in SQL Server?original ↗
12 Oct 2011
UPDATE statement with new .WRITE Clause – SQL Serveroriginal ↗
4 Oct 2011
more examples on querying XML …with CROSS APPLY & XQuery – in SQL Serveroriginal ↗
22 Sept 2011
Stored Procedures vs Functions (Difference between SP & UDF) – SQL Serveroriginal ↗
21 Sept 2011
BCP { IN | OUT | QUERYOUT } – the BCP util in SQL Serveroriginal ↗
9 Sept 2011
SQL Trivia – Reverse a string without using T-SQL REVERSE() functionoriginal ↗
18 Aug 2011
SQL Server 2012 (DENALI) TSQL – New Feature in SSMS – Surround Withoriginal ↗
5 Aug 2011
SQL Server 2012 (DENALI) TSQL – New feature | OFFSET FETCH Clause (for paging/pagination)original ↗
28 Jul 2011
SQL Server 2012 (DENALI) TSQL – New features | Built-in Functionsoriginal ↗
27 Jul 2011
DB Basics – Is SELECT a DML (Data Manipulation Language)?original ↗
26 Jul 2011
SQL Server 2012 (DENALI) TSQL – New Feature | SEQUENCESoriginal ↗
26 Jul 2011
DIRTY reads and PHANTOM reads – SQL Serveroriginal ↗
20 Jul 2011
SELECT or Query nodes in hierarchial or nested XMLoriginal ↗
13 Jul 2011
Query XML string in tabular format – SQL Serveroriginal ↗
13 Jul 2011
Check and ReSeed IDENTITY column value in a tableoriginal ↗
8 Jul 2011
Programming is like a Dream… by Lisaoriginal ↗
5 Jul 2011
SQL Query for calculating Running Totalsoriginal ↗
4 Jul 2011
SQL DBA – SHRINK DATABASE & SHRINK FILE – SQL Serveroriginal ↗
2 Jul 2011
TSQL Interview Questions – Part 4original ↗
1 Jul 2011
Are User Defined Functions (UDF) pre-compiled – MSDN TSQL forumoriginal ↗
15 Jun 2011
Logging in SSIS… using SQL Server Log Provideroriginal ↗
15 Jun 2011
SQL DBA – DBID 32767 | Resource Databaseoriginal ↗
3 Jun 2011
CTE Recursion | Sequence, Dates, Factorial, Fibonacci seriesoriginal ↗
23 May 2011
SQL Error – Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS…original ↗
20 May 2011
Database Schema difforiginal ↗
16 May 2011
Select multiple number of OrderIDs and send the criteria to a Stored Procedure parameter – MSDN TSQL forumoriginal ↗
21 Apr 2011
Error while Querying Excel file – The Microsoft Access database engine could not find the object ‘Sheet1$’ – MSDN TSQL Forumoriginal ↗
14 Apr 2011
SQL Basics – Working with NOT NULL, DEFAULT and CHECK Constraints (Domain Integrity)original ↗
11 Apr 2011
more on – ORDER BY with CASEoriginal ↗
9 Apr 2011
Autocommit Transactions with SQL Server – MSDN TSQL forumoriginal ↗
7 Apr 2011
How to retrieve last 12 months records form a table – MSDN TSQL forumoriginal ↗
24 Mar 2011
Using OUTPUT Parameters in Stored Proceduresoriginal ↗
23 Mar 2011
EXECUTE (or EXEC) vs sp_executesqloriginal ↗
22 Mar 2011
Is WITH (READPAST) affected by readlocks – MSDN TSQL forumoriginal ↗
19 Mar 2011
Convert unicode Characters to be displayed in ASCII format – MSDN TSQL forumoriginal ↗
18 Mar 2011
SQL DBA – SQL Queries Executed, Running & Blockingoriginal ↗
11 Mar 2011
Previous Next