SQL Deprecated Feature Archives - Page 2 of 2 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Use Always Outer Join Clause instead of (= and =)

August 27, 2007

SQL Deprecated Feature, SQL Joins, SQL Scripts

Yesterday I wrote about how SQL Server 2005 does not support named pipes. Today, my friend called me asking some of his query does not work. I asked him to send me the queries. I asked him to send me query. I noticed in his queries something, I have never…

SQL SERVER – 2005 – DBCC ROWLOCK – Deprecated

April 26, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Deprecated Feature, SQL Server DBCC

Title says all. My search engine log says many web users are looking for DBCC ROWLOCK in SQL SERVER 2005. It is deprecated feature for SQL SERVER 2005. It is Automatically on for SQL SERVER 2005. More Deprecated Features of SQL SERVER 2005 Refer MSDN Discontinued Database Engine Functionality in…

SQL SERVER – 2005 – Use Always Outer Join Clause instead of (*= and =*)

SQL SERVER – 2005 – DBCC ROWLOCK – Deprecated

SQL SERVER – 2005 – Use Always Outer Join Clause instead of (= and =)