New and Improved DMVs in SQL Server 2008 R2 SP1
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,336 reads
With relatively little fanfare, Microsoft added a few new DMVs into the SQL Server 2008 R2 SP1 release, which came...
2011-10-10
1,336 reads
Microsoft has released the final, RTM version of SQL Server 2008 Service Pack 3. This is build 10.00.5500. It includes...
2011-10-07
1,635 reads
Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...
2011-09-27
1,237 reads
Volume 2 of the SQL Server MVP Deep Dives book is now available for pre-order from Amazon and from Manning....
2011-09-24
1,920 reads
Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information...
2011-09-21
788 reads
Sticking to their eight week release cycle, Microsoft has released two different Cumulative Updates (CU) for SQL Server 2008. The...
2011-09-20
1,786 reads
The slide deck for my session Hardware 301: Diving Deeper into Database Hardware is available here. There are still twelve...
2011-09-07
574 reads
Just in case you forgot, I wanted to remind everyone that the free, 24 Hours of PASS online event starts...
2011-09-06
639 reads
As you may know from reading my blog, I buy quite a bit of computer hardware components from places like...
2011-09-04
727 reads
Primate Labs has released Geekbench 2.2.0, which is a free upgrade for Geekbench 2.1.x users. The release notes are here.
Here...
2011-09-01
929 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers