Visual Studio 2008 says the server version is not supported when you connect to SQL Server 2008. Install Visual Studio Service Pack 1 and it connects fine.
SQLAuthority Author Visit – Ahmedabad User Group Meeting September 2008
Every third Saturday is the Ahmedabad User Group Meeting. Today I present SQL Server CTE and Recursive CTE, followed by a real life CTE example by Jacob.
Interview Questions and Answers Complete List Download
The SQL Server 2008 Interview Questions and Answers Complete List in one place. A good interview leads to a good career if the candidate is willing to learn.
SQL SERVER – 2008 – Interview Questions and Answers Part 8
SQL Server 2008 Interview Questions and Answers Part 8 starts with Data Compression: how row compression and page compression work and save space.
SQL SERVER – 2008 – Interview Questions and Answers Part 7
SQL Server 2008 Interview Questions and Answers Part 7: how to rewrite sub-queries with joins or a CTE, what CLR is, and more answers with examples.
SQL SERVER – Interview Questions and Answers – Part 6
Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.
SQL SERVER – 2008 – Interview Questions and Answers Part 5
SQL Server 2008 Interview Questions and Answers Part 5: how to rename a db with sp_renamedb, and a table or a column with sp_rename, with examples.
SQL SERVER – 2008 – Interview Questions and Answers Part 4
SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.
SQL SERVER – 2008 – Interview Questions and Answers Part 3
SQL Server 2008 Interview Questions and Answers Part 3: which TCP/IP port SQL Server uses, and the difference between a clustered and non-clustered index.
SQL SERVER – Interview Questions and Answers – Part 2
This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox