Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008
In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...
2010-01-20
902 reads
In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are...
2010-01-20
902 reads
Microsoft has released Cumulative Update 6 (CU6) for SQL Server 2008 SP1, which you can request here. This is Build...
2010-01-19
1,745 reads
I was tagged by Steve Jones in the meme that Paul Randal started a few days ago, so I need...
2010-01-19
827 reads
I had a hardware issue this past weekend on one of my database servers where I am running SQL Server...
2010-01-18
1,523 reads
Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon...
2010-01-18
853 reads
Microsoft and Prometric have renewed their Second Shot promotion for certification exams. This allows you to retake a failed exam...
2010-01-16
902 reads
Back in October, I ordered one of the new TED 5000 energy monitors directly from Energy, Inc. in Charleston, SC....
2010-01-16
814 reads
Since quite a few PASS 2009 speakers have gone public with their speaker evaluation scores, I might as well do...
2010-01-15
765 reads
As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA...
2010-01-15
723 reads
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,414 reads
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
I have a numeric column called "Value" in a flat file, which contains both...
I have a numeric column called "Value" in a flat file, which contains both...
Comments posted to this topic are about the item Are We Dinosaurs?
What happens with this code:
DECLARE @Iteration INT = 0; WHILE @Iteration < 10 SELECT CustomerName, CustomerStatus FROM dbo.Customer WHERE CustomerID > 3; SET @Iteration += 1;See possible answers