“What will be the order of the result set of a SELECT statement on clustered indexed table when the ORDER BY clause is not used?”
SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management
I just came across PDF published by Microsoft to promote SQL Server 2005. I find few things very interesting. I will list them here.
NASDAQ
SQLAuthority News – Book Review – Pro T-SQL 2005 Programmer’s Guide (Paperback)
Pro T-SQL 2005 Programmer’s Guide (Paperback) Book Review
SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
While writing article based on my SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key I got an idea about writing this article. I was thinking if you can find primary key for any table in the database, you can sure find foreign key for any table in the database as well.
SQL SERVER – T-SQL Script to Attach and Detach Database
Following script can be used to detach or attach the database. If the database is to be from one database to another database following script can be used to detach from old server and attach to a new server. Let us learn about how to Attach and Detach Database.
SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code
Very simple and very effective. We use all the time for many reasons – formatting, while creating dynamically generated SQL to separate GO command from other T-SQL, saving some user input text to database etc. Let us learn about T-SQL Script to Insert Carriage Return and New Line Feed in Code.
SQL SERVER – 2008 – Book On-Line Link – BOL
I am researching SQL Server. Those who are asking me questions about SQL Server 2008, please refer following link. I will post my tutorials and articles very soon. Books Online is commonly known as BOL.