STATS_DATE() Doesn’t Indicate The Validity of Statistics
From time to time, you might have caught yourself in a conversation similar to the following:
Fred: Hey folks, we have...
2013-01-17
1,269 reads
Blog Posts
The right terminology for the right audience
For those who has the privilege of being in the technology consulting industry for some time and started out in...
2013-01-17
395 reads
Using New Horizontal/Vertical Tab Groups
This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently....
2013-01-17 (first published: 2013-01-14)
3,294 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 3: Decision Trees
by Steve Bolton
This series of self-tutorials is an elementary-level introduction to SQL Server Data Mining (SSDM), not the product...
2013-01-16
2,943 reads
Chad Churchwell: Protect Your Replication Environment with AlwaysOn Availability Groups
Heads up everyone. Next Tuesday January 22nd, 2013 Chad Churchwell (blog | twitter) will be presenting a webinar on behalf of...
2013-01-16
1,104 reads
Day 14 of 31 Days of Disaster Recovery: Fixing a Corrupt Tempdb
Welcome to day 14 of my 31 Days of Disaster Recovery series. I’ve previously discussed handling corruption for nonclustered indexes...
2013-01-16
2,233 reads
Execution Plans on Azure SQL Database Portal
If you’ve been working with the Azure SQL Database portal, you know that you have a query window. Within the...
2013-01-16 (first published: 2013-01-14)
1,852 reads
New Year Ambitions – Brent Ozar – Consulting
You are of course someone who needs little introduction in the SQL Server community. A prolific blogger, tweeter, speaker, Microsoft...
2013-01-16
1,880 reads
SQL Server Auto grow
I had a great response to my blog post and poll last week about how DBAs use auto grow. In...
2013-01-16
1,026 reads
SSIS Top 10 Best Practices Basics
Best Practice is a difficult one... It generally depends on many factors. In my opinion SSIS Best practice is a...
2013-01-16
1,802 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers