Updated Overlapping Statistics Scripts
Last year I published a script for identifying automatically generated column statistics that overlapped index statistics. I've updated the script...
2011-04-05
1,697 reads
Blog Posts
#Meme Monday
Use extended events; they work – and make you appear magical.
– “Write a SQL blog post in 11 words or less”...
2011-04-04
630 reads
A SQL Server Hardware Nugget A Day – Day 4
Day 4 of this series is about the upcoming AMD “Bulldozer” family of processors that is due to be released...
2011-04-04
387 reads
A SQL Story in Eleven Words or Less
Tom LaRock (blog | twitter) proposed a Meme Monday and his first choice of topics was to write a SQL Server...
2011-04-04
700 reads
Developing with SQL Server: Three ways to get at data
Getting at data within a .NET application can be straightforward using built in controls or much more complex through connections,...
2011-04-04
2,441 reads
Find tables which are most commonly used in Stored Procedures
When you start working on a new project, one of the important tasks as a database developer is to get...
2011-04-04
109 reads
Isolating SQL Server from other systems
In a recent explanation about the RSA breach, Rick Wanner wrote on the Internet Storm Center (ISC) Diary:
The traditional paradigm...
2011-04-04
2,157 reads
Meme Monday
Meme Monday story:
They’d never heard of indexes. Man, I was SUCH a rockstar!
-Jen McCown, MidnightDBA.com/Jen
2011-04-04
596 reads
2011-04-04
619 reads
Meme Monday
Replication: It's Not Really As Bad As SQLRockStar Says It Is
(Wondering what the heck this is supposed to be about?...
2011-04-04
397 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers