SQL Server 2005 and 2008 on same developer machine? *

Question Has anyone tried installing SQL Server 2008 Developer on a machine that already has 2005 Developer installed? I am unsure if I...

Read More

How do I know which SQL Server 2005 index recommendations to implement, if any? *

Question We're in the process of upgrading one of our SQL Server instances from 2000 to 2005. I installed the performance dashboard ( ht...

Read More

Paging SQL Server 2005 Results *

Question How do I page results in SQL Server 2005? I tried it in SQL Server 2000, but there was no reliable way to do this. I'm now w...

Read More

SQL Server 2005 For XML Explicit - Need help formatting *

Question I have a table with a structure like the following: ------------------------------ LocationID | AccountNumber --------------...

Read More

How do I split a string so I can access item x *

Question Using SQL Server 2005, how do I split a string so I can access item x? For example, take the string "Hello John Smith"...

Read More

Have you ever encountered a query that SQL Server could not execute because it referenced too many tables? *

Question Have you ever seen any of there error messages? -- SQL Server 2000 Could not allocate ancillary table for view or funct...

Read More