Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,643 reads
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,643 reads
On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...
2012-01-12
1,165 reads
Somewhat unnoticed during the holiday season, HP has submitted a new TPC-E benchmark for the DL385 G7 two socket database...
2012-01-04
1,628 reads
Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some...
2011-12-29
2,025 reads
On December 19, 2011, Microsoft released SQL Server 2008 R2 RTM Cumulative Update 11 (CU11), which is Build 10.50.1807.0. I...
2011-12-26
1,451 reads
On December 19, 2011, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 4 (CU4), which is Build 10.50.2796. I...
2011-12-26
3,024 reads
One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is...
2011-12-12
1,221 reads
I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6,...
2011-12-04
863 reads
Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core...
2011-11-30
942 reads
SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had...
2011-11-29
781 reads
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...
I wanted to figure out how big (or approximately how big) my dump file...
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
Comments posted to this topic are about the item New SQL Server 2022 Functions
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