Readers often ask how to check existence of a temp table and how to drop temp table without Msg 2714. My earlier article answers all of these questions.
SQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends
TechEd India 2009 has ended. Day 3 was the best, with a meeting with the SQL Server product group under NDA, final presentations and time with friends.
SQLAuthority News – TechEd India 2009 – Day 2 – In-Person Meeting with Industry Leaders – Community Party
Day 2 of TechEd India 2009 was even better: talks with industry leaders, Vinod Kumar’s session on data compression in SQL Server 2008, and a community party.
SQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People
The first day of TechEd India 2009 was a blast: Steve Ballmer’s keynote, my tech session with the SQL Server cheat sheet, and meeting great people.
SQLAuthority News – TechEd India 2009 – Day 0 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Catch Me Live
I am at TechEd India 2009 in Hyderabad, leading a session on SQL Server Management Studio 2008 new features. Catch me live and grab my SQL Server cheat sheet.
What Changes When You Move to a New Major Version
A New Major Version of SQL Server changes the engine while database compatibility, query plans, and deprecated features need separate review.
SQL SERVER – How to Drop Primary Key Constraint
ALTER TABLE … DROP PRIMARY KEY is MySQL syntax and fails in SQL Server with Msg 156. Here is how to drop primary key constraint the SQL Server way.