corpus.blog
56,966 blogs · [ { "id": "01a0d1d4-8e85-73e4-9863-0ba12d5f50c5", "title": "SQL DBA – When was the Table, View, Stored Procedure Created or Modified", "url": "https://sqlwithmanoj.com/2011/03/03/when-was-the-table-view-proc-created-or-modified/", "published_at": "2011-03-03T09:12:56+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba12de5d097", "title": "Clustered vs NonClustered Indexes… and data sorting in SQL Server", "url": "https://sqlwithmanoj.com/2011/03/02/clustered-vs-nonclustered-indexes-and-data-sorting/", "published_at": "2011-03-02T08:07:14+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba12e0fb4fd", "title": "Generate SCRIPT or SOURCE CODE of DB Objects: Functions, Stored Procedures, Views, Triggers, ect", "url": "https://sqlwithmanoj.com/2011/02/24/generate-script-or-source-code-of-db-objects-functions-stored-procedures-views-triggers/", "published_at": "2011-02-24T08:05:17+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba12ef42e62", "title": "Using ORDER BY with CASE in SQL Queries", "url": "https://sqlwithmanoj.com/2011/02/22/order-by-with-case/", "published_at": "2011-02-22T04:37:13+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba12f97a00e", "title": "Microsoft Community Contributor Award 2011", "url": "https://sqlwithmanoj.com/2011/02/17/microsoft-community-contributor-award-2011/", "published_at": "2011-02-17T02:00:19+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1301149d4", "title": "Import Excel Sheet with multiple Recordsets", "url": "https://sqlwithmanoj.com/2011/02/16/import-excel-sheet-with-multiple-recordsets/", "published_at": "2011-02-16T17:56:57+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13027257d", "title": "[NOT] IN, [NOT] EXISTS, JOINS with NULL values", "url": "https://sqlwithmanoj.com/2011/02/15/not-in-not-exists-joins-with-null-values/", "published_at": "2011-02-15T12:58:15+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba130bcc9d9", "title": "TSQL Interview Questions – Part 3", "url": "https://sqlwithmanoj.com/2011/02/10/tsql-interview-questions-part-3/", "published_at": "2011-02-10T11:26:20+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13121e4c3", "title": "Clustered Indexes, Non Clustered Indexes & why?", "url": "https://sqlwithmanoj.com/2011/02/09/clustered-indexes-non-clustered-indexes-why/", "published_at": "2011-02-09T10:34:22+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba131341fd5", "title": "Avoid CURSORS? why not use them optimally…", "url": "https://sqlwithmanoj.com/2011/02/07/avoid-cursors-or-use-them-optimally/", "published_at": "2011-02-07T18:22:56+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1321e6c6d", "title": "Excel data validation with VBA macros", "url": "https://sqlwithmanoj.com/2011/02/04/excel-data-validation-with-vba-macros/", "published_at": "2011-02-04T11:36:31+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba132ee3334", "title": "SELECT an XML string to a table – SQL Server", "url": "https://sqlwithmanoj.com/2011/01/28/select-an-xml-to-table/", "published_at": "2011-01-28T08:31:06+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1330a4981", "title": "Using SQL_VARIANT datatype to store any datatype value in SQL Server", "url": "https://sqlwithmanoj.com/2011/01/27/sql_variant-datatype/", "published_at": "2011-01-27T12:02:34+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba133d21e54", "title": "Creating “Dynamic PIVOT” scripts in SQL Server", "url": "https://sqlwithmanoj.com/2011/01/25/dynamic-pivot/", "published_at": "2011-01-25T12:07:53+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1346cb4f9", "title": "UNION vs UNION ALL | which one is faster?", "url": "https://sqlwithmanoj.com/2011/01/14/union-vs-union-all-which-one-is-faster/", "published_at": "2011-01-14T14:54:34+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba134db7cb8", "title": "SQL Jokes!!!", "url": "https://sqlwithmanoj.com/2011/01/10/sql-jokes/", "published_at": "2011-01-10T11:52:20+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba135917b69", "title": "TSQL Interview Questions – Part 2", "url": "https://sqlwithmanoj.com/2011/01/10/tsql-interview-questions-part-2/", "published_at": "2011-01-10T05:04:17+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba135a6e13b", "title": "2010 in review…", "url": "https://sqlwithmanoj.com/2011/01/02/2010-in-review/", "published_at": "2011-01-02T22:31:06+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba136537c78", "title": "Why UNION ALL is faster than UNION?", "url": "https://sqlwithmanoj.com/2010/12/30/why-union-all-is-faster-than-union/", "published_at": "2010-12-30T07:46:29+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba136d78f26", "title": "ISNULL vs COALESCE – expressions/functions in SQL Server", "url": "https://sqlwithmanoj.com/2010/12/23/isnull-vs-coalesce/", "published_at": "2010-12-23T18:32:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba137445ef4", "title": "Convert Hex to String – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2010/12/22/convert-hex-to-string-msdn-tsql-forum/", "published_at": "2010-12-22T14:46:46+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1384149c1", "title": "SQL Error – UPDATE statement conflicted with the FOREIGN KEY/REFERENCE constraint", "url": "https://sqlwithmanoj.com/2010/12/21/update-statement-conflicted-with-the-reference-constraint/", "published_at": "2010-12-21T14:03:01+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1391db3b1", "title": "CROSS APPLY vs OUTER APPLY operators in SQL Server", "url": "https://sqlwithmanoj.com/2010/12/11/cross-apply-outer-apply/", "published_at": "2010-12-11T17:52:36+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba139d67e8f", "title": "SQL Basics – UDF | User Defined Functions – Scalar, Table Valued (TVF), MultiStatement (MTVF)", "url": "https://sqlwithmanoj.com/2010/12/11/udf-user-defined-functions-scalar-table-valued-itv-multiselect-mtv/", "published_at": "2010-12-11T14:07:11+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba139ffd3ea", "title": "SET ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_PADDING – SQL Server", "url": "https://sqlwithmanoj.com/2010/12/10/set-ansi_nulls-quoted_identifier-ansi_padding/", "published_at": "2010-12-10T14:39:01+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13a6e90be", "title": "TSQL Interview Questions – Part 1", "url": "https://sqlwithmanoj.com/2010/12/09/tsql-interview-questions/", "published_at": "2010-12-09T14:40:55+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13a90152f", "title": "SQL DBA – Querying SQL Server Metadata, INFORMATION_SCHEMA, sysObjects, System Catalog, etc", "url": "https://sqlwithmanoj.com/2010/12/06/querying-sql-server-metadata/", "published_at": "2010-12-06T05:20:54+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13abf1fc9", "title": "MS SQL Server (TSQL) Interview Questions", "url": "https://sqlwithmanoj.com/2010/12/04/ms-sql-server-tsql-interview-questions/", "published_at": "2010-12-04T03:42:32+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13bb37a4c", "title": "OUTPUT clause and MERGE statement in SQL Server", "url": "https://sqlwithmanoj.com/2010/11/25/output-clause-with-merge/", "published_at": "2010-11-25T14:10:56+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13c864018", "title": "SQL Server 2012, codename Denali – New Features", "url": "https://sqlwithmanoj.com/2010/11/24/sql-server-11-codename-denali-new-features/", "published_at": "2010-11-24T21:43:14+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13cf6691f", "title": "DB Basics – Integrity Constraints in a Database (SQL Server)", "url": "https://sqlwithmanoj.com/2010/11/23/integrity-constraints/", "published_at": "2010-11-23T04:24:33+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13d042341", "title": "CUBE, ROLLUP, COMPUTE, COMPUTE BY, GROUPING SETS", "url": "https://sqlwithmanoj.com/2010/11/12/cube-rollup-compute-compute-by-grouping-sets/", "published_at": "2010-11-12T10:19:54+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13df0cb84", "title": "Query Excel file source through Linked Server", "url": "https://sqlwithmanoj.com/2010/11/12/query-excel-file-source-through-linked-server/", "published_at": "2010-11-12T09:08:35+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13e29151f", "title": "Creating Linked Server in SQL Server", "url": "https://sqlwithmanoj.com/2010/11/10/linked-server-in-ms-sql-server/", "published_at": "2010-11-10T11:24:52+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13e98b9c0", "title": "SQL Logical Query Processing Order", "url": "https://sqlwithmanoj.com/2010/10/28/sql-logical-query-processing-order/", "published_at": "2010-10-28T19:07:28+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba13f7916b3", "title": "SQL Server CURSOR and it’s Life Cycle", "url": "https://sqlwithmanoj.com/2010/10/24/sql-server-cursor-life-cycle/", "published_at": "2010-10-24T18:37:39+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1400a5f81", "title": "SQL Basics – IDENTITY property of a Column (in a table)", "url": "https://sqlwithmanoj.com/2010/10/19/sql-basics-identity-property-of-a-column-in-a-table/", "published_at": "2010-10-19T14:03:14+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba140ef944c", "title": "Multiple ways to INSERT records in a table", "url": "https://sqlwithmanoj.com/2010/10/15/multiple-ways-to-insert-records-in-a-table/", "published_at": "2010-10-15T17:54:39+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1414742c1", "title": "Physical Join vs Logical Join in SQL Server", "url": "https://sqlwithmanoj.com/2010/10/06/physical-join-vs-logical-join/", "published_at": "2010-10-06T09:39:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba141dcdab4", "title": "SQL DBA – Database Mail Setup – SQL Server 2005", "url": "https://sqlwithmanoj.com/2010/09/29/database-mail-setup-sql-server-2005/", "published_at": "2010-09-29T13:55:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba141df54cf", "title": "difference between COUNT() and COUNT_BIG() – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2010/09/28/difference-between-count-and-count_big-msdn-tsql-forum/", "published_at": "2010-09-28T04:45:24+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1421a9a33", "title": "Include other columns while doing aggregates and GROUP BY – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2010/09/22/include-other-columns-while-doing-aggregates-and-group-by-msdn-tsql-forum/", "published_at": "2010-09-22T03:30:20+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1426d6503", "title": "Defensive Database Programming with SQL Server… a must have (e)book", "url": "https://sqlwithmanoj.com/2010/09/21/defensive-database-programming-with-sql-server-a-must-have-ebook/", "published_at": "2010-09-21T09:09:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba142fad7e4", "title": "Stopping a DELETE statement in middle of its execution – MSDN TSQL forum", "url": "https://sqlwithmanoj.com/2010/09/17/stopping-a-delete-statement-in-middle-of-its-execution-msdn-tsql-forum/", "published_at": "2010-09-17T08:24:41+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba14320a74d", "title": "Combine multiple ROWS to CSV String… and vice-versa", "url": "https://sqlwithmanoj.com/2010/09/16/combine-multiple-rows-to-csv-string-and-vice-versa/", "published_at": "2010-09-16T13:24:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba143bc1ac4", "title": "Convert multiple Rows into a single column", "url": "https://sqlwithmanoj.com/2010/08/17/convert-multiple-rows-into-a-single-column/", "published_at": "2010-08-17T15:10:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba143f62bd3", "title": "Using OVER and PARTION BY clauses with Aggregate Functions in SQL Server", "url": "https://sqlwithmanoj.com/2010/08/10/using-over-and-partion-by-clauses-with-aggregate-functions-in-sql-server/", "published_at": "2010-08-10T10:55:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba14441fa38", "title": "Ranking Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILE", "url": "https://sqlwithmanoj.com/2010/08/09/ranking-functions-with-sql-server-2005/", "published_at": "2010-08-09T20:33:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba144aac006", "title": "Table variables are not stored in memory, but in tempdb", "url": "https://sqlwithmanoj.com/2010/07/20/table-variables-are-not-stored-in-memory-but-in-tempdb/", "published_at": "2010-07-20T12:13:00+00:00" }, { "id": "01a0d1d4-8e85-73e4-9863-0ba1451beb49", "title": "TRY CATCH – Exception Handling in SQL Server", "url": "https://sqlwithmanoj.com/2010/06/16/try-catch-exception-handling/", "published_at": "2010-06-16T13:20:48+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b7e51d1f2", "title": "SQL Basics – Backup and Restore Database in SQL Server", "url": "https://sqlwithmanoj.com/2010/06/05/sql-basics-backup-and-restore-database-in-sql-server/", "published_at": "2010-06-04T21:02:15+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b7ebce349", "title": "SQL basics – Temporary Tables vs Table Variables", "url": "https://sqlwithmanoj.com/2010/05/15/temporary-tables-vs-table-variables/", "published_at": "2010-05-15T17:49:00+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b7f5ff7ad", "title": "Basic UNIX/Linux commands for Interview Questions – Part 2", "url": "https://sqlwithmanoj.com/2010/04/15/basic-unixlinux-commands-for-interview-questions-part-2/", "published_at": "2010-04-15T12:42:00+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b7fe1fc46", "title": "Basic UNIX/Linux commands for Interview Questions – Part 1", "url": "https://sqlwithmanoj.com/2010/04/11/basic-unixlinux-commands-for-interview-questions-part-1/", "published_at": "2010-04-11T12:26:49+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8097ed5d", "title": "SQL DBA – Change a Database Collation in SQL Server", "url": "https://sqlwithmanoj.com/2010/03/25/change-a-database-collation/", "published_at": "2010-03-25T15:29:00+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8136ba48", "title": "SQL DBA – Collation Conflict in SQL Server", "url": "https://sqlwithmanoj.com/2010/02/23/collation-conflict-in-sql-server/", "published_at": "2010-02-23T11:52:00+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b81f2f8bc", "title": "C++ Program to implement File Handling With Class Objects – Q32", "url": "https://sqlwithmanoj.com/2010/02/01/c-program-to-implement-file-handling-with-class-objects-q32/", "published_at": "2010-02-01T06:01:34+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b82d5b13f", "title": "C++ Program to implement File Handling with Command Line Arguments – Q31", "url": "https://sqlwithmanoj.com/2010/01/31/c-program-to-implement-file-handling-with-command-line-arguments-q31/", "published_at": "2010-01-30T18:57:50+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b83ce1fef", "title": "C++ Program to implement File Handling by using ifstream & ofstream (Prg-2) – Q30", "url": "https://sqlwithmanoj.com/2010/01/30/c-program-to-implement-file-handling-by-using-ifstream-ofstream-prg-2-q30/", "published_at": "2010-01-29T18:53:52+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8463a11f", "title": "C++ Program to implement File Handling by using ifstream & ofstream (Prg-1) – Q29", "url": "https://sqlwithmanoj.com/2010/01/29/c-program-to-implement-file-handling-by-using-ifstream-ofstream-prg-1-q29/", "published_at": "2010-01-28T18:48:30+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b85498deb", "title": "C++ Program to implement Exception Handling by using TRY CATCH – Q28", "url": "https://sqlwithmanoj.com/2010/01/28/c-program-to-implement-exception-handling-by-using-try-catch-q28/", "published_at": "2010-01-27T18:45:57+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b85a2595a", "title": "C++ Program to implement Generic Classes for maintaining Linked List – Q27", "url": "https://sqlwithmanoj.com/2010/01/27/c-program-to-implement-generic-classes-for-maintaining-linked-list-q27/", "published_at": "2010-01-26T18:41:15+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8624902a", "title": "C++ Program to implement Generic classes for maintaining Stack – Q26", "url": "https://sqlwithmanoj.com/2010/01/26/c-program-to-implement-generic-classes-for-maintaining-stack-q26/", "published_at": "2010-01-25T18:38:05+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b86bbec38", "title": "C++ Program to implement Generic Classes for user defined maths library – Q25", "url": "https://sqlwithmanoj.com/2010/01/25/c-program-to-implement-generic-classes-for-user-defined-maths-library-q25/", "published_at": "2010-01-24T18:34:18+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b87150889", "title": "C++ Program to implement Virtual Functions – Q24", "url": "https://sqlwithmanoj.com/2010/01/24/c-program-to-implement-virtual-functions-q24/", "published_at": "2010-01-23T18:30:24+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b87eb2d8a", "title": "C++ Program to implement Virtual Class by using Multipath Inheritance – Q23", "url": "https://sqlwithmanoj.com/2010/01/23/c-program-to-implement-virtual-class-by-using-multipath-inheritance-q23/", "published_at": "2010-01-23T18:23:18+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8831812d", "title": "C++ Program to implement Multiple Inheritance – Q22", "url": "https://sqlwithmanoj.com/2010/01/22/c-program-to-implement-multiple-inheritance-q22/", "published_at": "2010-01-22T18:20:45+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b887b6422", "title": "C++ Program to implement Hierarchical Inheritance (Part 2) – Q21", "url": "https://sqlwithmanoj.com/2010/01/21/c-program-to-implement-hierarchical-inheritance-part-2-q21/", "published_at": "2010-01-21T18:17:41+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b88c26e4f", "title": "C++ Program to implement Hierarchical Inheritance (Part 1) – Q20", "url": "https://sqlwithmanoj.com/2010/01/20/c-program-to-implement-hierarchical-inheritance-part-1-q20/", "published_at": "2010-01-20T18:14:45+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b89310da3", "title": "C++ Program to implement Operator Overloading (>>,", "url": "https://sqlwithmanoj.com/2010/01/19/c-program-to-implement-operator-overloading-q19/", "published_at": "2010-01-19T18:10:08+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b89f73793", "title": "C++ Program to implement Operator Overloading for String Comparison with relational op (+, , ==) – Q18", "url": "https://sqlwithmanoj.com/2010/01/18/c-program-to-implement-operator-overloading-for-string-comparison-with-relational-op-q18/", "published_at": "2010-01-18T18:05:31+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8a40dd36", "title": "C++ Program to implement Operator Overloading with binary arithmetic op (*,+,-) – Q17", "url": "https://sqlwithmanoj.com/2010/01/17/c-program-to-implement-operator-overloading-with-binary-arithmetic-op-q17/", "published_at": "2010-01-17T18:02:47+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8a48459c", "title": "C++ Program to implement Operator Overloading with Unary Operators (++, –) – Q16", "url": "https://sqlwithmanoj.com/2010/01/16/c-program-to-implement-operator-overloading-with-unary-operators-q16/", "published_at": "2010-01-16T17:59:42+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8b2bfc73", "title": "C++ Program to implement Dynamic Class with Constructor & Destructor – Q15", "url": "https://sqlwithmanoj.com/2010/01/15/c-program-to-implement-dynamic-class-with-constructor-destructor-q15/", "published_at": "2010-01-15T17:56:46+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8bc26623", "title": "C++ Program to implement Pointer to function – Q14", "url": "https://sqlwithmanoj.com/2010/01/14/c-program-to-implement-pointer-to-function-q14/", "published_at": "2010-01-14T17:53:25+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8c2b1b2e", "title": "C++ Program to implement Constructor Overloading – Q13", "url": "https://sqlwithmanoj.com/2010/01/13/c-program-to-implement-constructor-overloading-q13/", "published_at": "2010-01-13T17:47:03+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8c85804e", "title": "Build ASP.net pages without coding with ASP.net Maker", "url": "https://sqlwithmanoj.com/2010/01/13/build-asp-net-pages-without-coding-with-asp-net-maker/", "published_at": "2010-01-13T14:43:00+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8d611eb2", "title": "C++ Program to implement Toll Tax Problem by using CLASS Access Specifiers and SWITCH CASE – Q12", "url": "https://sqlwithmanoj.com/2010/01/12/c-program-to-implement-toll-tax-problem-by-using-class-access-specifiers-and-switch-case-q12/", "published_at": "2010-01-12T17:42:23+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8e01a246", "title": "C++ Program for CLASS Array Addition & Swapping by using Friend function – Q11", "url": "https://sqlwithmanoj.com/2010/01/11/c-program-for-class-array-addition-swapping-by-using-friend-function-q11/", "published_at": "2010-01-11T17:33:46+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8eb4d4c0", "title": "C++ Program to work with Purchase Order Problem by using Pointers and CLASS with PUBLIC & PRIVATE Access Specifiers – Q10", "url": "https://sqlwithmanoj.com/2010/01/10/c-program-to-work-with-purchase-order-problem-by-using-pointers-and-class-with-public-private-access-specifiers-q10/", "published_at": "2010-01-10T14:45:08+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b8fa6a989", "title": "C++ Program to maintain a Cricket Team by using CLASS with PUBLIC & PRIVATE Access Specifiers – Q9", "url": "https://sqlwithmanoj.com/2010/01/09/c-program-to-maintain-a-cricket-team-by-using-class-with-public-private-access-specifiers-q9/", "published_at": "2010-01-09T14:41:34+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b90a5f11a", "title": "C++ Program to implement Function Overloading – Q8", "url": "https://sqlwithmanoj.com/2010/01/08/c-program-to-implement-function-overloading-q8/", "published_at": "2010-01-08T14:37:02+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b917cdb5c", "title": "C++ Program to maintain Student Result by using CLASS with PUBLIC & PRIVATE Access Specifiers – Q7", "url": "https://sqlwithmanoj.com/2010/01/07/c-program-to-maintain-student-result-by-using-class-with-public-private-access-specifiers-q7/", "published_at": "2010-01-07T14:25:24+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b91c9dc2e", "title": "C++ Program for Matrix manipulation (menu based) by using Multi Dimensional Array and SWITCH CASE – Q6", "url": "https://sqlwithmanoj.com/2010/01/06/c-program-for-matrix-manipulation-menu-based-by-using-multi-dimensional-array-and-switch-case-q6/", "published_at": "2010-01-06T14:19:15+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b922ecc56", "title": "C++ Program for String Manipulation (menu based) by using SWITCH CASE – Q5", "url": "https://sqlwithmanoj.com/2010/01/05/c-program-for-string-manipulation-menu-based-by-using-switch-case-q5/", "published_at": "2010-01-05T14:40:36+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b92f06f27", "title": "C++ Program to check Command Line Arguments – Q4", "url": "https://sqlwithmanoj.com/2010/01/04/c-program-to-check-command-line-arguments-q4/", "published_at": "2010-01-04T14:35:09+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b93185f86", "title": "C++ Program for Array Sorting, Searching and Deletion of element by using Pointers – Q3", "url": "https://sqlwithmanoj.com/2010/01/03/c-program-for-array-sorting-searching-and-deletion-of-element-by-using-pointers-q3/", "published_at": "2010-01-03T12:04:57+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b93844a70", "title": "C++ Program to find Sum of Series (When n is Odd/Even) – Q2", "url": "https://sqlwithmanoj.com/2010/01/02/c-program-to-find-sum-of-series-when-n-is-oddeven/", "published_at": "2010-01-02T09:37:54+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b93a0ca68", "title": "C++ Program to find Roots (Real & Complex) of a Quadratic Equation – Q1", "url": "https://sqlwithmanoj.com/2010/01/01/c-program-to-find-roots-real-complex-of-a-quadratic-equation/", "published_at": "2010-01-01T07:18:59+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b93d05ac8", "title": "SQL Basics – Working with Foreign Key (FK) constraints", "url": "https://sqlwithmanoj.com/2009/12/27/sql-basics-working-with-foreign-key-fk-constraints/", "published_at": "2009-12-27T16:49:43+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b9406e9bc", "title": "C++ Graphics – 21 – Analog Clock code/program showing current time", "url": "https://sqlwithmanoj.com/2009/12/21/c-graphics-21-analog-clock-codeprogram-showing-current-time/", "published_at": "2009-12-21T15:18:32+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b944276a5", "title": "C++ Graphics – 20 – SCALING of LINE, TRIANGLE and RECTANGLE w.r.t a Point", "url": "https://sqlwithmanoj.com/2009/12/20/c-graphics-20-scaling-of-line-triangle-and-rectangle-w-r-t-a-point/", "published_at": "2009-12-20T14:59:31+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b94b58590", "title": "C++ Graphics – 19 – ROTATION of LINE, TRIANGLE and RECTANGLE w.r.t a Point", "url": "https://sqlwithmanoj.com/2009/12/19/c-graphics-19-rotation-of-line-triangle-and-rectangle-w-r-t-a-point/", "published_at": "2009-12-19T14:58:06+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b954af5a9", "title": "C++ Graphics – 18 – SHEARING of LINE, TRIANGLE and RECTANGLE w.r.t xy-Axis", "url": "https://sqlwithmanoj.com/2009/12/18/c-graphics-18-shearing-of-line-triangle-and-rectangle-w-r-t-xy-axis/", "published_at": "2009-12-18T14:56:56+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b95aa8ac1", "title": "C++ Graphics – 17 – SHEARING of LINE, TRIANGLE and RECTANGLE w.r.t y-Axis", "url": "https://sqlwithmanoj.com/2009/12/17/c-graphics-17-shearing-of-line-triangle-and-rectangle-w-r-t-y-axis/", "published_at": "2009-12-17T14:55:34+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b962b65a5", "title": "C++ Graphics – 16 – SHEARING of LINE, TRIANGLE and RECTANGLE w.r.t x-Axis", "url": "https://sqlwithmanoj.com/2009/12/16/c-graphics-16-shearing-of-line-triangle-and-rectangle-w-r-t-x-axis/", "published_at": "2009-12-16T14:54:15+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b965c51e9", "title": "C++ Graphics – 15 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t y=-x Axis", "url": "https://sqlwithmanoj.com/2009/12/15/c-graphics-15-reflection-of-line-triangle-and-rectangle-w-r-t-y-x-axis/", "published_at": "2009-12-15T14:53:01+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b9704cd3d", "title": "C++ Graphics – 14 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t y=x Axis", "url": "https://sqlwithmanoj.com/2009/12/14/c-graphics-14-reflection-of-line-triangle-and-rectangle-w-r-t-yx-axis/", "published_at": "2009-12-14T14:48:33+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b97f7663a", "title": "C++ Graphics – 13 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t y-axis", "url": "https://sqlwithmanoj.com/2009/12/13/c-graphics-13-reflection-of-line-triangle-and-rectangle-w-r-t-y-axis/", "published_at": "2009-12-13T14:47:00+00:00" }, { "id": "01a0d1d4-bf37-70b1-a1c7-7f7b98017b41", "title": "C++ Graphics – 12 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t x-axis", "url": "https://sqlwithmanoj.com/2009/12/12/c-graphics-12-reflection-of-line-triangle-and-rectangle-w-r-t-x-axis/", "published_at": "2009-12-12T14:45:13+00:00" } ] posts Claim your blog
Back to sqlwithmanoj.com
Blog · corpus.blog/blogs/sqlwithmanoj.com/posts

sqlwithmanoj.com

sqlwithmanoj.com

2011

SQL DBA – When was the Table, View, Stored Procedure Created or Modifiedoriginal ↗
3 Mar 2011
Clustered vs NonClustered Indexes… and data sorting in SQL Serveroriginal ↗
2 Mar 2011
Generate SCRIPT or SOURCE CODE of DB Objects: Functions, Stored Procedures, Views, Triggers, ectoriginal ↗
24 Feb 2011
Using ORDER BY with CASE in SQL Queriesoriginal ↗
22 Feb 2011
Microsoft Community Contributor Award 2011original ↗
17 Feb 2011
Import Excel Sheet with multiple Recordsetsoriginal ↗
16 Feb 2011
[NOT] IN, [NOT] EXISTS, JOINS with NULL valuesoriginal ↗
15 Feb 2011
TSQL Interview Questions – Part 3original ↗
10 Feb 2011
Clustered Indexes, Non Clustered Indexes & why?original ↗
9 Feb 2011
Avoid CURSORS? why not use them optimally…original ↗
7 Feb 2011
Excel data validation with VBA macrosoriginal ↗
4 Feb 2011
SELECT an XML string to a table – SQL Serveroriginal ↗
28 Jan 2011
Using SQL_VARIANT datatype to store any datatype value in SQL Serveroriginal ↗
27 Jan 2011
Creating “Dynamic PIVOT” scripts in SQL Serveroriginal ↗
25 Jan 2011
UNION vs UNION ALL | which one is faster?original ↗
14 Jan 2011
SQL Jokes!!!original ↗
10 Jan 2011
TSQL Interview Questions – Part 2original ↗
10 Jan 2011
2010 in review…original ↗
2 Jan 2011

2010

Why UNION ALL is faster than UNION?original ↗
30 Dec 2010
ISNULL vs COALESCE – expressions/functions in SQL Serveroriginal ↗
23 Dec 2010
Convert Hex to String – MSDN TSQL forumoriginal ↗
22 Dec 2010
SQL Error – UPDATE statement conflicted with the FOREIGN KEY/REFERENCE constraintoriginal ↗
21 Dec 2010
CROSS APPLY vs OUTER APPLY operators in SQL Serveroriginal ↗
11 Dec 2010
SQL Basics – UDF | User Defined Functions – Scalar, Table Valued (TVF), MultiStatement (MTVF)original ↗
11 Dec 2010
SET ANSI_NULLS, QUOTED_IDENTIFIER, ANSI_PADDING – SQL Serveroriginal ↗
10 Dec 2010
TSQL Interview Questions – Part 1original ↗
9 Dec 2010
SQL DBA – Querying SQL Server Metadata, INFORMATION_SCHEMA, sysObjects, System Catalog, etcoriginal ↗
6 Dec 2010
MS SQL Server (TSQL) Interview Questionsoriginal ↗
4 Dec 2010
OUTPUT clause and MERGE statement in SQL Serveroriginal ↗
25 Nov 2010
SQL Server 2012, codename Denali – New Featuresoriginal ↗
24 Nov 2010
DB Basics – Integrity Constraints in a Database (SQL Server)original ↗
23 Nov 2010
CUBE, ROLLUP, COMPUTE, COMPUTE BY, GROUPING SETSoriginal ↗
12 Nov 2010
Query Excel file source through Linked Serveroriginal ↗
12 Nov 2010
Creating Linked Server in SQL Serveroriginal ↗
10 Nov 2010
SQL Logical Query Processing Orderoriginal ↗
28 Oct 2010
SQL Server CURSOR and it’s Life Cycleoriginal ↗
24 Oct 2010
SQL Basics – IDENTITY property of a Column (in a table)original ↗
19 Oct 2010
Multiple ways to INSERT records in a tableoriginal ↗
15 Oct 2010
Physical Join vs Logical Join in SQL Serveroriginal ↗
6 Oct 2010
SQL DBA – Database Mail Setup – SQL Server 2005original ↗
29 Sept 2010
difference between COUNT() and COUNT_BIG() – MSDN TSQL forumoriginal ↗
28 Sept 2010
Include other columns while doing aggregates and GROUP BY – MSDN TSQL forumoriginal ↗
22 Sept 2010
Defensive Database Programming with SQL Server… a must have (e)bookoriginal ↗
21 Sept 2010
Stopping a DELETE statement in middle of its execution – MSDN TSQL forumoriginal ↗
17 Sept 2010
Combine multiple ROWS to CSV String… and vice-versaoriginal ↗
16 Sept 2010
Convert multiple Rows into a single columnoriginal ↗
17 Aug 2010
Using OVER and PARTION BY clauses with Aggregate Functions in SQL Serveroriginal ↗
10 Aug 2010
Ranking Functions | ROW_NUMBER, RANK, DENSE_RANK, NTILEoriginal ↗
9 Aug 2010
Table variables are not stored in memory, but in tempdboriginal ↗
20 Jul 2010
TRY CATCH – Exception Handling in SQL Serveroriginal ↗
16 Jun 2010
SQL Basics – Backup and Restore Database in SQL Serveroriginal ↗
4 Jun 2010
SQL basics – Temporary Tables vs Table Variablesoriginal ↗
15 May 2010
Basic UNIX/Linux commands for Interview Questions – Part 2original ↗
15 Apr 2010
Basic UNIX/Linux commands for Interview Questions – Part 1original ↗
11 Apr 2010
SQL DBA – Change a Database Collation in SQL Serveroriginal ↗
25 Mar 2010
SQL DBA – Collation Conflict in SQL Serveroriginal ↗
23 Feb 2010
C++ Program to implement File Handling With Class Objects – Q32original ↗
1 Feb 2010
C++ Program to implement File Handling with Command Line Arguments – Q31original ↗
30 Jan 2010
C++ Program to implement File Handling by using ifstream & ofstream (Prg-2) – Q30original ↗
29 Jan 2010
C++ Program to implement File Handling by using ifstream & ofstream (Prg-1) – Q29original ↗
28 Jan 2010
C++ Program to implement Exception Handling by using TRY CATCH – Q28original ↗
27 Jan 2010
C++ Program to implement Generic Classes for maintaining Linked List – Q27original ↗
26 Jan 2010
C++ Program to implement Generic classes for maintaining Stack – Q26original ↗
25 Jan 2010
C++ Program to implement Generic Classes for user defined maths library – Q25original ↗
24 Jan 2010
C++ Program to implement Virtual Functions – Q24original ↗
23 Jan 2010
C++ Program to implement Virtual Class by using Multipath Inheritance – Q23original ↗
23 Jan 2010
C++ Program to implement Multiple Inheritance – Q22original ↗
22 Jan 2010
C++ Program to implement Hierarchical Inheritance (Part 2) – Q21original ↗
21 Jan 2010
C++ Program to implement Hierarchical Inheritance (Part 1) – Q20original ↗
20 Jan 2010
C++ Program to implement Operator Overloading (>>,original ↗
19 Jan 2010
C++ Program to implement Operator Overloading for String Comparison with relational op (+, , ==) – Q18original ↗
18 Jan 2010
C++ Program to implement Operator Overloading with binary arithmetic op (*,+,-) – Q17original ↗
17 Jan 2010
C++ Program to implement Operator Overloading with Unary Operators (++, –) – Q16original ↗
16 Jan 2010
C++ Program to implement Dynamic Class with Constructor & Destructor – Q15original ↗
15 Jan 2010
C++ Program to implement Pointer to function – Q14original ↗
14 Jan 2010
C++ Program to implement Constructor Overloading – Q13original ↗
13 Jan 2010
Build ASP.net pages without coding with ASP.net Makeroriginal ↗
13 Jan 2010
C++ Program to implement Toll Tax Problem by using CLASS Access Specifiers and SWITCH CASE – Q12original ↗
12 Jan 2010
C++ Program for CLASS Array Addition & Swapping by using Friend function – Q11original ↗
11 Jan 2010
C++ Program to work with Purchase Order Problem by using Pointers and CLASS with PUBLIC & PRIVATE Access Specifiers – Q10original ↗
10 Jan 2010
C++ Program to maintain a Cricket Team by using CLASS with PUBLIC & PRIVATE Access Specifiers – Q9original ↗
9 Jan 2010
C++ Program to implement Function Overloading – Q8original ↗
8 Jan 2010
C++ Program to maintain Student Result by using CLASS with PUBLIC & PRIVATE Access Specifiers – Q7original ↗
7 Jan 2010
C++ Program for Matrix manipulation (menu based) by using Multi Dimensional Array and SWITCH CASE – Q6original ↗
6 Jan 2010
C++ Program for String Manipulation (menu based) by using SWITCH CASE – Q5original ↗
5 Jan 2010
C++ Program to check Command Line Arguments – Q4original ↗
4 Jan 2010
C++ Program for Array Sorting, Searching and Deletion of element by using Pointers – Q3original ↗
3 Jan 2010
C++ Program to find Sum of Series (When n is Odd/Even) – Q2original ↗
2 Jan 2010
C++ Program to find Roots (Real & Complex) of a Quadratic Equation – Q1original ↗
1 Jan 2010

2009

SQL Basics – Working with Foreign Key (FK) constraintsoriginal ↗
27 Dec 2009
C++ Graphics – 21 – Analog Clock code/program showing current timeoriginal ↗
21 Dec 2009
C++ Graphics – 20 – SCALING of LINE, TRIANGLE and RECTANGLE w.r.t a Pointoriginal ↗
20 Dec 2009
C++ Graphics – 19 – ROTATION of LINE, TRIANGLE and RECTANGLE w.r.t a Pointoriginal ↗
19 Dec 2009
C++ Graphics – 18 – SHEARING of LINE, TRIANGLE and RECTANGLE w.r.t xy-Axisoriginal ↗
18 Dec 2009
C++ Graphics – 17 – SHEARING of LINE, TRIANGLE and RECTANGLE w.r.t y-Axisoriginal ↗
17 Dec 2009
C++ Graphics – 16 – SHEARING of LINE, TRIANGLE and RECTANGLE w.r.t x-Axisoriginal ↗
16 Dec 2009
C++ Graphics – 15 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t y=-x Axisoriginal ↗
15 Dec 2009
C++ Graphics – 14 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t y=x Axisoriginal ↗
14 Dec 2009
C++ Graphics – 13 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t y-axisoriginal ↗
13 Dec 2009
C++ Graphics – 12 – Reflection of LINE, TRIANGLE and RECTANGLE w.r.t x-axisoriginal ↗
12 Dec 2009
Previous Next