SQL Server 2008 Diagnostic Information Queries (Late November 2009)
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008. Running these queries will give you...
2009-11-24
2,429 reads
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008. Running these queries will give you...
2009-11-24
2,429 reads
PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the...
2009-11-23
979 reads
If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it...
2009-11-23
503 reads
During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in...
2009-11-19
1,012 reads
Back before I grew up and became a DBA, I used to be a developer. This seems to be a...
2009-11-18
481 reads
Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 1. You can go here to request the...
2009-11-17
527 reads
We have been using SQL Server 2008 Integrated Full Text Search (iFTS) in Production at NewsGator for a little over...
2009-11-17
945 reads
Kimberly Trippposted today about the SQL Server MVP Deep Dives book signing event at PASS on November 4. The PASS...
2009-11-17
641 reads
If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you...
2009-11-14
1,429 reads
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-13
1,310 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
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