| RANK |
KEYWORD |
WEB TITLE & WEB URL |
TIME |
| 1 - 1 |
nested cte in sql server 2005 |
SQL Server – Multiple CTE in One SELECT Statement Query « SQL ... 
blog.sqlauthority.com/2009/08/08/sql-server-multiple-cte-in-one-select-statement-query/
|
2012-12-17 02:21:21 |
| 1 - 1 |
case statement syntax sql server 2005 |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-17 02:21:48 |
| 1 - 1 |
sql server host name |
SQL SERVER – Find Hostname and Current Logged In User Name ...
blog.sqlauthority.com/2009/05/26/sql-server-find-hostname-and-current-logged-in-user-name/
|
2012-12-17 02:34:30 |
| 1 - 2 |
case statement sql server 2005 |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-17 02:21:36 |
| 1 - 2 |
sql server 2005 case statement example |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-17 02:21:45 |
| 1 - 2 |
select case sql server |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-18 13:29:18 |
| 1 - 2 |
case statements sql server |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-18 13:30:45 |
| 1 - 3 |
case sql server 2005 |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-18 13:29:20 |
| 1 - 3 |
cast sql server |
SQL SERVER – Convert Text to Numbers (Integer) – CAST and ...
blog.sqlauthority.com/2007/07/07/sql-server-convert-text-to-numbers-integer-cast-and-convert/
|
2012-12-18 13:29:36 |
| 1 - 3 |
patindex sql |
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX ...
blog.sqlauthority.com/2007/04/08/sql-server-search-text-field-charindex-vs-patindex/
|
2012-12-19 04:33:58 |
| 1 - 4 |
decode sql code |
Using Decode in SQL Server - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/04/23/sql-server-using-decode-in-sql-server/
|
2012-12-17 02:21:06 |
| 1 - 4 |
sql server 2005 nested triggers |
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting
blog.sqlauthority.com/2007/05/18/sql-server-2005-understanding-trigger-recursion-and-nesting-with-examples/
|
2012-12-17 02:21:24 |
| 1 - 4 |
case statement sql server 2005 msdn |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-17 02:21:54 |
| 1 - 4 |
isnull sql server |
Explanation and Comparison of NULLIF and - SQL Server Journey ...
blog.sqlauthority.com/2007/06/22/sql-server-explanation-and-comparison-of-nullif-and-isnull/
|
2012-12-18 13:29:38 |
| 1 - 5 |
if sql server |
SQL SERVER – 2005 – Find Index Fragmentation Details – Slow ...
blog.sqlauthority.com/2008/03/27/sql-server-2005-find-index-fragmentation-details-slow-index-performance/
|
2012-12-18 13:29:34 |
| 1 - 6 |
nested iif sql |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-17 02:22:11 |
| 1 - 7 |
nested query in sql server 2005 |
SQL SERVER – Correlated and Noncorrelated – SubQuery ...
blog.sqlauthority.com/2007/09/07/sql-server-correlated-and-noncorrelated-subquery-introduction-explanation-and-example/
|
2012-12-17 02:21:33 |
| 1 - 7 |
case null sql server 2005 |
Explanation and Comparison of NULLIF and - SQL Server Journey ...
blog.sqlauthority.com/2007/06/22/sql-server-explanation-and-comparison-of-nullif-and-isnull/
|
2012-12-17 02:21:39 |
| 1 - 7 |
parallelism sql 2005 |
CXPACKET – Parallelism - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/02/06/sql-server-cxpacket-parallelism-usual-solution-wait-type-day-6-of-28/
|
2012-12-19 23:36:07 |
| 1 - 7 |
case function sql server |
SQL SERVER – UDF – Function to Convert Text String to Title Case ...
blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case/
|
2012-12-18 13:19:03 |
| 1 - 8 |
case function sql server |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-18 13:19:03 |
| 1 - 8 |
case sql server 2000 |
CASE Statement in ORDER BY Clause - SQL Server Journey with ...
blog.sqlauthority.com/2007/07/17/sql-server-case-statement-in-order-by-clause-order-by-using-variable/
|
2012-12-18 13:29:23 |
| 1 - 9 |
sql backup devices |
FIX – ERROR : Msg 3201, Level 16 Cannot open backup device ...
blog.sqlauthority.com/2011/12/17/sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-3-the-system-cannot-find-the-path-specified/
|
2012-12-17 00:35:50 |
| 2 - 1 |
sql backup devices |
FIX – ERROR : Msg 3201, Level 16 Cannot open backup device ...
blog.sqlauthority.com/2011/04/13/sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-5access-is-denied/
|
2012-12-17 00:35:50 |
| 2 - 1 |
t sql right join |
SQL SERVER – Challenge – Puzzle – Why does RIGHT JOIN Exists ...
blog.sqlauthority.com/2010/11/28/sql-server-challenge-puzzle-why-does-right-join-exists/
|
2012-12-18 19:38:59 |
| 2 - 1 |
sql server right string |
SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width ...
blog.sqlauthority.com/2009/03/10/sql-server-pad-ride-side-of-number-with-0-fixed-width-number-display/
|
2012-12-18 19:39:33 |
| 2 - 1 |
select count |
Puzzle – SELECT * vs SELECT COUNT(*) - SQL Server Journey ...
blog.sqlauthority.com/2011/05/30/sql-server-puzzle-select-vs-select-count/
|
2012-12-17 04:48:33 |
| 2 - 1 |
sql query select count |
Puzzle – SELECT * vs SELECT COUNT(*) - SQL Server Journey ...
blog.sqlauthority.com/2011/05/30/sql-server-puzzle-select-vs-select-count/
|
2012-12-17 06:03:38 |
| 2 - 2 |
sql server 2005 case statement null |
Explanation and Comparison of NULLIF and - SQL Server Journey ...
blog.sqlauthority.com/2007/06/22/sql-server-explanation-and-comparison-of-nullif-and-isnull/
|
2012-12-17 02:21:51 |
| 2 - 3 |
nested if sql server 2005 |
SQL SERVER – 2005/2000 Examples and Explanation for GOTO ...
blog.sqlauthority.com/2007/05/07/sql-server-20052000-examples-and-explanation-for-goto/
|
2012-12-17 02:21:27 |
| 2 - 4 |
nested if sql server 2005 |
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting
blog.sqlauthority.com/2007/05/18/sql-server-2005-understanding-trigger-recursion-and-nesting-with-examples/
|
2012-12-17 02:21:27 |
| 2 - 4 |
replace sql |
SQL SERVER – Replace a Column Name in Multiple Stored ...
blog.sqlauthority.com/2012/09/21/sql-server-replace-a-column-name-in-multiple-stored-procedure-all-together/
|
2012-12-19 04:34:18 |
| 2 - 5 |
sql server definition |
SQL SERVER – Definition, Comparison and Difference between ...
blog.sqlauthority.com/2007/07/04/sql-server-definition-comparison-and-difference-between-having-and-where-clause/
|
2012-12-18 19:24:55 |
| 2 - 6 |
sql server case when null |
SQL SERVER – Puzzle Involving NULL – Resolve – Error ...
blog.sqlauthority.com/2011/06/27/sql-server-puzzle-involving-null-resolve-error-operand-data-type-void-type-is-invalid-for-sum-operator/
|
2012-12-18 13:30:37 |
| 2 - 7 |
nested cte in sql server 2005 |
SQL SERVER – Common Table Expression (CTE) and Few ...
blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/
|
2012-12-17 02:21:21 |
| 2 - 7 |
sql server 2005 case statement example |
CASE Statement in ORDER BY Clause - SQL Server Journey with ...
blog.sqlauthority.com/2007/07/17/sql-server-case-statement-in-order-by-clause-order-by-using-variable/
|
2012-12-17 02:21:45 |
| 2 - 7 |
sql server case when null |
Explanation and Comparison of NULLIF and - SQL Server Journey ...
blog.sqlauthority.com/2007/06/22/sql-server-explanation-and-comparison-of-nullif-and-isnull/
|
2012-12-18 13:30:37 |
| 2 - 8 |
t sql right function |
SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width ...
blog.sqlauthority.com/2009/03/10/sql-server-pad-ride-side-of-number-with-0-fixed-width-number-display/
|
2012-12-17 16:13:09 |
| 2 - 8 |
sql server case when null |
SQL SERVER – Curious Case of Disappearing Rows – ON ...
blog.sqlauthority.com/2012/08/17/sql-server-curious-case-of-disappearing-rows-on-update-cascade-and-on-delete-cascade-t-sql-example-part-2-of-2/
|
2012-12-18 13:30:37 |
| 2 - 10 |
sql email validation |
Selecting Domain from Email Address - SQL Server Journey with ...
blog.sqlauthority.com/2011/06/18/sql-server-selecting-domain-from-email-address/
|
2012-12-17 04:57:12 |
| 3 - 1 |
substring charindex sql |
Selecting Domain from Email Address - SQL Server Journey with ...
blog.sqlauthority.com/2011/06/18/sql-server-selecting-domain-from-email-address/
|
2012-12-19 04:34:08 |
| 3 - 5 |
server backup devices |
FIX – ERROR : Msg 3201, Level 16 Cannot open backup device ...
blog.sqlauthority.com/2011/12/17/sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-3-the-system-cannot-find-the-path-specified/
|
2012-12-17 00:35:00 |
| 3 - 6 |
if sql server |
Detect Fragmentation and Eliminate Fragmentation - SQL Server ...
blog.sqlauthority.com/2010/01/12/sql-server-fragmentation-detect-fragmentation-and-eliminate-fragmentation/
|
2012-12-18 13:29:34 |
| 3 - 7 |
if sql server |
SQL SERVER – Asynchronous Update and Timestamp – Check if ...
blog.sqlauthority.com/2012/12/11/sql-server-asynchronous-update-and-timestamp-check-if-row-values-are-changed-since-last-retrieve/
|
2012-12-18 13:29:34 |
| 3 - 9 |
research database definition |
SQL SERVER – Spatial Database Definition and Research ...
blog.sqlauthority.com/2007/06/09/sql-server-spatial-database-definition-and-research-documents/
|
2012-12-18 11:10:35 |
| 3 - 10 |
case statement sql server 2005 |
CASE Statement in ORDER BY Clause - SQL Server Journey with ...
blog.sqlauthority.com/2007/07/17/sql-server-case-statement-in-order-by-clause-order-by-using-variable/
|
2012-12-17 02:21:36 |
| 3 - 10 |
case statement sql server 2005 msdn |
Collate – Case Sensitive SQL Query Search - SQL Server Journey ...
blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
|
2012-12-17 02:21:54 |
| 4 - 5 |
sql server 2005 case statement example |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-17 02:21:45 |
| 4 - 6 |
case statement samples |
CASE Statement/Expression Examples and Explanation
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-17 01:42:44 |
| 4 - 6 |
sql right function |
SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width ...
blog.sqlauthority.com/2009/03/10/sql-server-pad-ride-side-of-number-with-0-fixed-width-number-display/
|
2012-12-18 19:28:33 |
| 4 - 6 |
database primary key definition |
SQL SERVER – Two Methods to Retrieve List of Primary Keys and ...
blog.sqlauthority.com/2009/07/17/sql-server-two-methods-to-retrieve-list-of-primary-keys-and-foreign-keys-of-database/
|
2012-12-19 07:47:58 |
| 4 - 7 |
introdunction data type |
Introduction to Discovering XML Data Type Methods – A Primer
blog.sqlauthority.com/2012/04/27/sql-server-introduction-to-discovering-xml-data-type-methods-a-primer/
|
2012-12-17 14:13:44 |
| 4 - 8 |
sql right string function |
SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width ...
blog.sqlauthority.com/2009/03/10/sql-server-pad-ride-side-of-number-with-0-fixed-width-number-display/
|
2012-12-18 19:29:18 |
| 4 - 9 |
server backup devices |
FIX – ERROR : Msg 3201, Level 16 Cannot open backup device ...
blog.sqlauthority.com/2011/04/13/sql-server-fix-error-msg-3201-level-16-cannot-open-backup-device-operating-system-error-5access-is-denied/
|
2012-12-17 00:35:00 |
| 4 - 9 |
case statement sql server 2005 |
Collate – Case Sensitive SQL Query Search - SQL Server Journey ...
blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
|
2012-12-17 02:21:36 |
| 4 - 9 |
nested if else in sql server 2005 |
SQL SERVER – 2005/2000 Examples and Explanation for GOTO ...
blog.sqlauthority.com/2007/05/07/sql-server-20052000-examples-and-explanation-for-goto/
|
2012-12-17 02:21:42 |
| 4 - 9 |
cast sql server |
Saturday Fun Puzzle with SQL Server DATETIME2 and CAST
blog.sqlauthority.com/2012/05/19/sql-server-saturday-fun-puzzle-with-sql-server-datetime2-and-cast/
|
2012-12-18 13:29:36 |
| 4 - 10 |
case function sql server |
Using Decode in SQL Server - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/04/23/sql-server-using-decode-in-sql-server/
|
2012-12-18 13:19:03 |
| 5 - 1 |
case sql server 2005 |
Collate – Case Sensitive SQL Query Search - SQL Server Journey ...
blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
|
2012-12-18 13:29:20 |
| 5 - 1 |
patindex sql |
Find First Non-Numeric Character from String - SQL Server Journey ...
blog.sqlauthority.com/2012/10/14/sql-server-find-first-non-numeric-character-from-string/
|
2012-12-19 04:33:58 |
| 5 - 2 |
case sql server 2005 |
Upper Case Shortcut SQL Server Management Studio
blog.sqlauthority.com/2010/07/07/sql-server-upper-case-shortcut-sql-server-management-studio/
|
2012-12-18 13:29:20 |
| 5 - 3 |
sql right function |
SQL SERVER – Lots of Date Functions – Find Right One to Use ...
blog.sqlauthority.com/2012/01/28/sql-server-lots-of-date-functions-find-right-one-to-use-quiz-puzzle-27-of-31/
|
2012-12-18 19:28:33 |
| 5 - 5 |
sql server case statement null |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-18 13:30:05 |
| 5 - 6 |
not null clause |
SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN ...
blog.sqlauthority.com/2009/03/15/sql-server-interesting-observation-of-on-clause-on-left-join-how-on-clause-effects-resultset-in-left-join/
|
2012-12-17 14:08:48 |
| 5 - 6 |
sql server case statement null |
SQL SERVER – Denali – New Functions and Shorthand for CASE ...
blog.sqlauthority.com/2011/09/13/sql-server-denali-new-functions-and-shorthand-for-case-statement-2/
|
2012-12-18 13:30:05 |
| 5 - 6 |
primary key data type |
SQL SERVER – Clustered Index and Primary Key – Contest Win ...
blog.sqlauthority.com/2012/08/08/sql-server-clustered-index-and-primary-key-contest-win-joes-2-pros-combo-usd-198-day-3-of-5/
|
2012-12-19 07:41:47 |
| 5 - 9 |
case function sql server |
SQL SERVER – CASE Statement/Expression Examples and ...
blog.sqlauthority.com/2007/04/14/sql-server-case-statementexpression-examples-and-explanation/
|
2012-12-18 13:19:03 |
| 5 - 9 |
case statements sql server |
SQL SERVER – A Puzzle – Swap Value of Column Without Case ...
blog.sqlauthority.com/2012/06/08/sql-server-a-puzzle-swap-value-of-column-without-case-statement/
|
2012-12-18 13:30:45 |
| 5 - 10 |
nested cte in sql server 2005 |
SQL SERVER – 2005 – 2008 – Delete Duplicate Rows « SQL ...
blog.sqlauthority.com/2009/06/23/sql-server-2005-2008-delete-duplicate-rows/
|
2012-12-17 02:21:21 |
| 5 - 10 |
case function sql server |
Introduction to Function SIGN - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2012/06/23/sql-server-introduction-to-function-sign/
|
2012-12-18 13:19:03 |
| 5 - 10 |
case statements sql server |
SQL SERVER – Denali – New Functions and Shorthand for CASE ...
blog.sqlauthority.com/2011/09/13/sql-server-denali-new-functions-and-shorthand-for-case-statement-2/
|
2012-12-18 13:30:45 |
| 5 - 10 |
meaning primary key |
SQL SERVER – Primary Key Constraints and Unique Key ...
blog.sqlauthority.com/2007/02/05/sql-server-primary-key-constraints-and-unique-key-constraints/
|
2012-12-19 07:35:47 |
| 6 - 1 |
t sql right function |
SQL SERVER – TRIM() Function – UDF TRIM() « SQL Server ...
blog.sqlauthority.com/2007/04/24/sql-server-trim-function-udf-trim/
|
2012-12-17 16:13:09 |
| 6 - 3 |
case null sql server 2005 |
SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ...
blog.sqlauthority.com/2007/03/05/sql-server-quoted_identifier-onoff-and-ansi_null-onoff-explanation/
|
2012-12-17 02:21:39 |
| 6 - 3 |
replace sql |
SQLAuthority News – Follow up on – Replace a Column Name in ...
blog.sqlauthority.com/2012/10/01/sqlauthority-news-follow-up-on-replace-a-column-name-in-multiple-stored-procedure-all-together/
|
2012-12-19 04:34:18 |
| 6 - 5 |
nested if sql server 2005 |
Concat Function in SQL Server – SQL Concatenation
blog.sqlauthority.com/2010/11/25/sql-server-concat-function-in-sql-server-sql-concatenation/
|
2012-12-17 02:21:27 |
| 6 - 6 |
sql server host name |
Fun Post – Connecting Same SQL Server using Different Methods
blog.sqlauthority.com/2012/09/07/sql-server-fun-post-connecting-same-sql-server-using-different-methods/
|
2012-12-17 02:34:30 |
| 6 - 6 |
pl sql inner join |
2005 – Difference Between INTERSECT and INNER JOIN
blog.sqlauthority.com/2008/08/03/sql-server-2005-difference-between-intersect-and-inner-join-intersect-vs-inner-join/
|
2012-12-17 16:14:01 |
| 6 - 6 |
case function sql server |
SQL SERVER – Solution to Puzzle – Simulate LEAD() and LAG ...
blog.sqlauthority.com/2011/11/24/sql-server-solution-to-puzzle-simulate-lead-and-lag-without-using-sql-server-2012-analytic-function/
|
2012-12-18 13:19:03 |
| 6 - 6 |
case sql server 2005 |
SQL SERVER – UDF – Function to Convert Text String to Title Case ...
blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case/
|
2012-12-18 13:29:20 |
| 6 - 7 |
case function sql server |
SQL SERVER – Denali – Conversion Function – TRY_PARSE() – A ...
blog.sqlauthority.com/2011/09/07/sql-server-denali-conversion-function-try_parse-a-quick-introduction/
|
2012-12-18 13:19:03 |
| 6 - 7 |
select case sql server |
SQL SERVER – A Puzzle – Swap Value of Column Without Case ...
blog.sqlauthority.com/2012/06/08/sql-server-a-puzzle-swap-value-of-column-without-case-statement/
|
2012-12-18 13:29:18 |
| 6 - 8 |
group vs order |
SQL SERVER – Difference between DISTINCT and GROUP BY ...
blog.sqlauthority.com/2007/03/29/sql-server-difference-between-distinct-and-group-by-distinct-vs-group-by/
|
2012-12-18 21:01:52 |
| 6 - 8 |
case function sql server |
SQL SERVER – A Puzzle – Swap Value of Column Without Case ...
blog.sqlauthority.com/2012/06/08/sql-server-a-puzzle-swap-value-of-column-without-case-statement/
|
2012-12-18 13:19:03 |
| 6 - 8 |
primary key data type |
A Common Design Problem – Should the Primary Key Always be a ...
blog.sqlauthority.com/2009/11/23/sql-server-a-common-design-problem-should-the-primary-key-always-be-a-clustered-index/
|
2012-12-19 07:41:47 |
| 6 - 9 |
case function sql server |
SQL SERVER – Denali – Logical Function – CHOOSE() – A Quick ...
blog.sqlauthority.com/2011/09/11/sql-server-denali-logical-function-choose-a-quick-introduction/
|
2012-12-18 13:19:03 |
| 6 - 10 |
t sql right join |
SQL SERVER- Differences Between Left Join and Left Outer Join ...
blog.sqlauthority.com/2011/01/22/sql-server-differences-between-left-join-and-left-outer-join/
|
2012-12-18 19:38:59 |
| 6 - 10 |
case function sql server |
UDF - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2008/08/22/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case-part-2/
|
2012-12-18 13:19:03 |
| 7 - 1 |
sql server definition |
SQL SERVER – Keywords View Definition Must Not Contain for ...
blog.sqlauthority.com/2010/09/27/sql-server-keywords-view-definition-must-not-contain-for-indexed-view-limitation-of-the-view-10/
|
2012-12-18 19:24:55 |
| 7 - 1 |
case sql server 2005 |
Explanation and Comparison of NULLIF and - SQL Server Journey ...
blog.sqlauthority.com/2007/06/22/sql-server-explanation-and-comparison-of-nullif-and-isnull/
|
2012-12-18 13:29:20 |
| 7 - 3 |
case statement sql server 2005 |
Dynamic Case Statement – FIX : ERROR 156 - SQL Server Journey ...
blog.sqlauthority.com/2008/02/28/sql-server-dynamic-case-statement-fix-error-156-incorrect-syntax-near-the-keyword/
|
2012-12-17 02:21:36 |
| 7 - 7 |
select case sql server |
Using Decode in SQL Server - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/04/23/sql-server-using-decode-in-sql-server/
|
2012-12-18 13:29:18 |
| 7 - 8 |
select case sql server |
Effect of Case Sensitive Collation on Resultset - SQL Server Journey ...
blog.sqlauthority.com/2012/07/12/sql-server-effect-of-case-sensitive-collation-on-resultset/
|
2012-12-18 13:29:18 |
| 7 - 8 |
substring charindex sql |
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX ...
blog.sqlauthority.com/2007/04/08/sql-server-search-text-field-charindex-vs-patindex/
|
2012-12-19 04:34:08 |
| 7 - 9 |
select case sql server |
SQL SERVER – Curious Case of Disappearing Rows – ON ...
blog.sqlauthority.com/2012/08/17/sql-server-curious-case-of-disappearing-rows-on-update-cascade-and-on-delete-cascade-t-sql-example-part-2-of-2/
|
2012-12-18 13:29:18 |
| 7 - 10 |
nested if else in sql server 2005 |
Concat Function in SQL Server – SQL Concatenation
blog.sqlauthority.com/2010/11/25/sql-server-concat-function-in-sql-server-sql-concatenation/
|
2012-12-17 02:21:42 |
| 7 - 10 |
cast sql server |
SQL SERVER – Get Answer in Float When Dividing of Two Integer ...
blog.sqlauthority.com/2008/09/26/sql-server-division-by-float/
|
2012-12-18 13:29:36 |
| 8 - 1 |
nested cursor sql server 2005 |
2005 – Explanation of TRY… - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/
|
2012-12-17 02:21:18 |
| 8 - 1 |
if sql server |
Detecting guest User Permissions - SQL Server Journey with SQL ...
blog.sqlauthority.com/2012/02/23/sql-server-detecting-guest-user-permissions-guest-user-access-status/
|
2012-12-18 13:29:34 |
| 8 - 2 |
nested query in sql server 2005 |
SQL SERVER – Interesting Observation – Query Hint – FORCE ...
blog.sqlauthority.com/2009/10/06/sql-server-interesting-observation-query-hint-force-order/
|
2012-12-17 02:21:33 |
| 8 - 2 |
case statement sql server 2005 msdn |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-17 02:21:54 |
| 8 - 2 |
sql server case when null |
SQL SERVER – Validating Spatial Object as NULL using IsNULL ...
blog.sqlauthority.com/2012/06/30/sql-server-validating-spatial-object-as-null-using-isnull/
|
2012-12-18 13:30:37 |
| 8 - 3 |
nested query in sql server 2005 |
SQL SERVER – Get Query Plan Along with Query Text and ...
blog.sqlauthority.com/2009/08/21/sql-server-get-query-plan-along-with-query-text-and-execution-count/
|
2012-12-17 02:21:33 |
| 8 - 4 |
case statement sql server 2005 |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-17 02:21:36 |
| 8 - 5 |
case statement sql server 2005 |
SQL SERVER – Common Table Expression (CTE) and Few ...
blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/
|
2012-12-17 02:21:36 |
| 8 - 5 |
select count |
SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT ...
blog.sqlauthority.com/2011/06/15/sql-server-solution-puzzle-select-vs-select-count/
|
2012-12-17 04:48:33 |
| 8 - 6 |
sql server 2005 nested triggers |
SQL SERVER – 2005 – Server and Database Level DDL Triggers ...
blog.sqlauthority.com/2007/07/24/sql-server-2005-server-and-database-level-ddl-triggers-examples-and-explanation/
|
2012-12-17 02:21:24 |
| 8 - 7 |
t sql right join |
Introduction to JOINs – Basic of JOINs - SQL Server Journey with ...
blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/
|
2012-12-18 19:38:59 |
| 8 - 8 |
sql server definition |
SQL SERVER – What is Interim Table – Simple Definition of Interim ...
blog.sqlauthority.com/2009/06/04/sql-server-what-is-interim-table-simple-definition-of-interim-table/
|
2012-12-18 19:24:55 |
| 8 - 8 |
case function sql server |
SQL SERVER – Denali – Conversion Function – TRY_CONVERT ...
blog.sqlauthority.com/2011/09/08/sql-server-denali-conversion-function-try_convert-a-quick-introduction/
|
2012-12-18 13:19:03 |
| 8 - 9 |
case function sql server |
SQL SERVER – Denali – New Functions and Shorthand for CASE ...
blog.sqlauthority.com/2011/09/13/sql-server-denali-new-functions-and-shorthand-for-case-statement-2/
|
2012-12-18 13:19:03 |
| 8 - 9 |
mysql sql case sensitive |
SQL SERVER – Case Sensitive Database and Database User – Fix ...
blog.sqlauthority.com/2012/02/18/sql-server-case-sensitive-database-and-database-user-fix-error-15151-cannot-find-the-user-because-it-does-not-exist-or-you-do-not-have-permission/
|
2012-12-18 13:28:46 |
| 8 - 9 |
cast sql server |
SQL SERVER – Puzzle – Challenge – Error While Converting ...
blog.sqlauthority.com/2010/11/27/sql-server-puzzle-challenge-error-while-converting-money-to-decimal/
|
2012-12-18 13:29:36 |
| 8 - 10 |
case statement syntax sql server 2005 |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-17 02:21:48 |
| 8 - 10 |
select case sql server |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-18 13:29:18 |
| 8 - 10 |
case statements sql server |
Solution of Puzzle - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2012/06/14/sql-server-solution-of-puzzle-swap-value-of-column-without-case-statement/
|
2012-12-18 13:30:45 |
| 9 - 4 |
select case sql server |
SQL SERVER – Denali – New Functions and Shorthand for CASE ...
blog.sqlauthority.com/2011/09/13/sql-server-denali-new-functions-and-shorthand-for-case-statement-2/
|
2012-12-18 13:29:18 |
| 9 - 4 |
meaning primary key |
Difference Between Candidate Keys and Primary Key - SQL Server ...
blog.sqlauthority.com/2009/05/30/sql-server-difference-between-candidate-keys-and-primary-key/
|
2012-12-19 07:35:47 |
| 9 - 5 |
sql server definition |
SQL SERVER – 2005 – Retrieve Any User Defined Object Details ...
blog.sqlauthority.com/2008/03/16/sql-server-2005-retrieve-any-user-defined-object-details-using-sysobjects-database/
|
2012-12-18 19:24:55 |
| 9 - 5 |
select case sql server |
Upper Case Shortcut SQL Server Management Studio
blog.sqlauthority.com/2010/07/07/sql-server-upper-case-shortcut-sql-server-management-studio/
|
2012-12-18 13:29:18 |
| 9 - 5 |
if sql server |
DELETE, TRUNCATE and RESEED Identity - SQL Server Journey ...
blog.sqlauthority.com/2012/08/24/sql-server-delete-truncate-and-reseed-identity/
|
2012-12-18 13:29:34 |
| 9 - 6 |
sql server definition |
Tips from the SQL Joes 2 - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/08/25/sql-server-tips-from-the-sql-joes-2-pros-development-series-table-valued-store-procedure-parameters-day-25-of-35/
|
2012-12-18 19:24:55 |
| 9 - 7 |
nested if sql server 2005 |
2005 – Explanation of TRY… - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/
|
2012-12-17 02:21:27 |
| 9 - 7 |
nested if sql server |
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting
blog.sqlauthority.com/2007/05/18/sql-server-2005-understanding-trigger-recursion-and-nesting-with-examples/
|
2012-12-17 02:21:58 |
| 9 - 8 |
case statement sql server 2005 msdn |
SQL SERVER – Logical Query Processing Phases – Order of ...
blog.sqlauthority.com/2009/04/06/sql-server-logical-query-processing-phases-order-of-statement-execution/
|
2012-12-17 02:21:54 |
| 9 - 8 |
blog interview questions |
SQL Interview Q & A « SQL Server Journey with SQL Authority
blog.sqlauthority.com/sql-server-interview-questions-and-answers/
|
2012-12-16 16:57:19 |
| 9 - 8 |
case function sql server |
Concat Function in SQL Server – SQL Concatenation
blog.sqlauthority.com/2010/11/25/sql-server-concat-function-in-sql-server-sql-concatenation/
|
2012-12-18 13:19:03 |
| 9 - 8 |
charindex mysql |
SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX ...
blog.sqlauthority.com/2007/04/08/sql-server-search-text-field-charindex-vs-patindex/
|
2012-12-19 04:34:03 |
| 9 - 9 |
case function sql server |
SQL SERVER – UDF – User Defined Function – Get Number of ...
blog.sqlauthority.com/2007/09/08/sql-server-udf-user-defined-function-get-number-of-days-in-month/
|
2012-12-18 13:19:03 |
| 9 - 9 |
isnull sql server |
SQL SERVER – Validating Spatial Object as NULL using IsNULL ...
blog.sqlauthority.com/2012/06/30/sql-server-validating-spatial-object-as-null-using-isnull/
|
2012-12-18 13:29:38 |
| 9 - 10 |
case function sql server |
SQL SERVER – Question to You – When to use Function and When ...
blog.sqlauthority.com/2011/06/04/sql-server-question-to-you-when-to-use-function-and-when-to-use-stored-procedure/
|
2012-12-18 13:19:03 |
| 9 - 10 |
case statements sql server |
Dynamic Case Statement – FIX : ERROR 156 - SQL Server Journey ...
blog.sqlauthority.com/2008/02/28/sql-server-dynamic-case-statement-fix-error-156-incorrect-syntax-near-the-keyword/
|
2012-12-18 13:30:45 |
| 9 - 10 |
replace sql |
SQL SERVER – Tricks to Replace SELECT * with Column Names ...
blog.sqlauthority.com/2012/06/06/sql-server-tricks-to-replace-select-with-column-names-sql-in-sixty-seconds-017-video/
|
2012-12-19 04:34:18 |
| 10 - 2 |
parallelism sql 2005 |
SQL SERVER – Find Queries using Parallelism from Cached Plan ...
blog.sqlauthority.com/2010/07/24/sql-server-find-queries-using-parallelism-from-cached-plan/
|
2012-12-19 23:36:07 |
| 10 - 3 |
nested if else in sql server 2005 |
2005 – Explanation of TRY… - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2007/04/11/sql-server-2005-explanation-of-trycatch-and-error-handling/
|
2012-12-17 02:21:42 |
| 10 - 3 |
parallelism sql 2005 |
SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific ...
blog.sqlauthority.com/2010/03/15/sql-server-maxdop-settings-to-limit-query-to-run-on-specific-cpu/
|
2012-12-19 23:36:07 |
| 10 - 4 |
nested if else in sql server 2005 |
Contact Me – Archive 7 « SQL Server Journey with SQL Authority
blog.sqlauthority.com/contact-me/contact-me-contact-pinaldave-archive-7/
|
2012-12-17 02:21:42 |
| 10 - 4 |
sql server case statement null |
SQL SERVER – Curious Case of Disappearing Rows – ON ...
blog.sqlauthority.com/2012/08/17/sql-server-curious-case-of-disappearing-rows-on-update-cascade-and-on-delete-cascade-t-sql-example-part-2-of-2/
|
2012-12-18 13:30:05 |
| 10 - 4 |
case statements sql server |
CASE Statement in ORDER BY Clause - SQL Server Journey with ...
blog.sqlauthority.com/2007/07/17/sql-server-case-statement-in-order-by-clause-order-by-using-variable/
|
2012-12-18 13:30:45 |
| 10 - 5 |
dictionary order case insensitive |
SQL SERVER – 2005 Collation Explanation and Translation « SQL ...
blog.sqlauthority.com/2007/04/24/sql-server-2005-collation-explanation-and-translation/
|
2012-12-18 13:26:44 |
| 10 - 5 |
sql server case statement null |
SQL SERVER – A Puzzle – Swap Value of Column Without Case ...
blog.sqlauthority.com/2012/06/08/sql-server-a-puzzle-swap-value-of-column-without-case-statement/
|
2012-12-18 13:30:05 |
| 10 - 5 |
case statements sql server |
Logical Function – IIF() - SQL Server Journey with SQL Authority
blog.sqlauthority.com/2011/09/10/sql-server-denali-logical-function-iif-a-quick-introduction/
|
2012-12-18 13:30:45 |
| 10 - 6 |
case sql server 2000 |
SQL SERVER – Get All the Information of Database using sys ...
blog.sqlauthority.com/2010/11/12/sql-server-get-all-the-information-of-database-using-sys-databases/
|
2012-12-18 13:29:23 |
| 10 - 7 |
case function sql server |
SQL SERVER – Function to Retrieve First Word of Sentence – String ...
blog.sqlauthority.com/2010/08/20/sql-server-function-to-retrieve-first-word-of-sentence-string-operation/
|
2012-12-18 13:19:03 |
| 10 - 7 |
select case sql server |
SQL SERVER – Detecting Database Case Sensitive Property using ...
blog.sqlauthority.com/2011/10/06/sql-server-detecting-database-case-sensitive-property-using-fn_helpcollations/
|
2012-12-18 13:29:18 |
| 10 - 8 |
select case sql server |
Collate – Case Sensitive SQL Query Search - SQL Server Journey ...
blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/
|
2012-12-18 13:29:18 |
| 10 - 8 |
if sql server |
SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider ...
blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
|
2012-12-18 13:29:34 |
| 10 - 8 |
patindex sql |
SQL SERVER – Get Numeric Value From Alpha Numeric String ...
blog.sqlauthority.com/2010/09/25/sql-server-get-numeric-value-from-alpha-numeric-string-get-numbers-only/
|
2012-12-19 04:33:58 |
| 10 - 9 |
nested query in sql server 2005 |
Concat Function in SQL Server – SQL Concatenation
blog.sqlauthority.com/2010/11/25/sql-server-concat-function-in-sql-server-sql-concatenation/
|
2012-12-17 02:21:33 |
| 10 - 10 |
nested query in sql server 2005 |
Two Different Ways to Comment Code - SQL Server Journey with ...
blog.sqlauthority.com/2007/08/03/sql-server-two-different-ways-to-comment-code-explanation-and-example/
|
2012-12-17 02:21:33 |
| 10 - 10 |
sql server 2005 case statement example |
SQL SERVER – Common Table Expression (CTE) and Few ...
blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/
|
2012-12-17 02:21:45 |
