SqlServer-QA.net

You might be aware (from other bloggers on this site) that there is a new web-only Books Online for SQL Server 2008 available at http://msdn.microsoft.com/en-us/library/dd239407.aspx.  Like Tibor, I prefer a downloadable BOL, partly because I do a lot of research and writing while traveling and I don't always have an internet connection, ...

  I just today found out about something that was in plain sight in the Books Online... but the documentation is so vast, I haven't discovered everything yet. I blogged about clearing a single plan from cache in SQL Server 2005 a while back, and mentioned a rumor that there would be a new way to do this in SQL Server 2008. And then just ...

I am very excited to be part of a new SQL Server Training Group, which was organized in the UK by 4 SQL Server MVPs (current and former).  I know this is a shameless plug, but I am not apologizing. I am actually going to the UK for the benefit of the SQLKnowHow guys, and I'm just trying to help them out even more by telling you all about ...

Have you tested or downloaded the SQL Server 2008 Evaluation edition to know about new features? Say if you need to determine which edition of SQL Server 2008 is suitable it is best to download Enterprise Evaluation Edition to test the application, based on the costings you could decide whether to use Enterprise, Standard or Workgroup editions of ...

As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create a table with LOTS of columns. First of all, you're probably aware of the new SPARSE column feature that allows you to have up to 30,000 columns in a table!  I did some testing with sparse columns, but just today I realized I ...

As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create a table with LOTS of columns. First of all, you're probably aware of the new SPARSE column feature that allows you to have up to 30,000 columns in a table!  I did some testing with sparse columns, but just today I realized I ...

I almost didn't respond to the request for an interview with Richard Morris of Simple Talk. There were a few strange things in the request that made me think it might be spam or phishing. But I asked some trusted colleagues, and found out it was for real, and you can read the result ...

I almost didn't respond to the request for an interview with Richard Morris of Simple Talk. There were a few strange things in the request that made me think it might be spam or phishing. But I asked some trusted colleagues, and found out it was for real, and you can read the result ...

Ok its time to update your local copies of SQL Server 2008 Books OnLine (BOL) too, as we have RTM version in hand. You may have installed it during CTP releases and even during short-time of RC0 release, but as always it is a good practice to update as the current installation is latest and updated. MSDN Developer Center page provides wide range ...

For attendees of last Thursday's talk on SQL Server Spatial for the masses, the demo code is located here. Thanks for coming and for your participation! This blog is sponsored by SQLSkills.