It IS NOT guaranteed! Your test cases are invalid! Case in point:

I have a table with an IDENTITY column as the PK with a clustered index on...

I totally...

I assign all of my SQL Server logins to the tempdb as the default database. NEVER master. This way no harm can be done by an application that...

lkent (9/26/2013)

---

In the healthcare industry, length of stay (LOS) is always fun figuring out how to present the data.

Usually we only count days stay with a default of 1. ...

This is my first interview question for anyone who will be working with SQL. I usually "mix it up" a bit by stating that the table has a clustered...

Another case where the SSMS GUI failed...

Bug in SSMS where page level locking is disabled.

http://www.interworks.com/blogs/bbickell/2010/05/10/sql-server-index-indexname-table-tablename-cannot-be-reorganized-because-p

Whereas, if the SQL DDL command to create the index was coded by hand, the coder...

I couldn't agree more. I hate the "noise" generated by SQL Server's reverse-engineering.

I've been coding RDBMS (IBM'S DB2, Oracle, SQL Server) code (DDL and DML) for 30 years. ...

Hugo Kornelis (3/21/2011)

---

stefan.hoffmann (3/21/2011)

---

hi Hugo,

I'd like to disagree. While the last example uses only @var = column the explanation above it clearly states:

"If a SELECT statement returns more than one...

There is a lot of reinvention of the wheel. I've worked with full-text in both Oracle (9i, 10g) and SQL Server (2000, 2005, 2008) as well as external, i.e.,...

Suresh Kumar-284278 (6/4/2012)

---

Hi ucbus,

I landed in your thread when searching for a similar solution. Thanks a lot for your effort and a sample script. However, is there a easy...

paul.morgan-1069605 (11/2/2011)

---

Thanks for all of this it was exactly what I was trying to solve. I'm using the XQUERY and have all good results except one particular node format.

The...

Greg Grater (8/29/2011)

---

Another great use for CONTEXT_INFO is auditing actions. Most web/windows applications create a helper class that manages opening a connection to the database. You...

My first computer. Extra points to those that can identify it.

First off, the "SQL_" prefixed default collation for a new installation of SQL Server is bad, bad, bad! This is a legacy collation going back to the "dark ages",...

Robert Bourdeau (3/4/2011)

---

It is a shame that TSQL lacks the CONNECT BY clause that is available with Oracle. All these complex solutions could be eliminated for many classes of row-joining...