What Queries are Causing My Waits?
In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once...
2013-10-15 (first published: 2013-10-10)
4,260 reads
Blog Posts
Finding Top Offenders From Cache
When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find...
2013-10-14
1,390 reads
Last Weeks Top “Reading” Links #53
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-14
768 reads
My PASS Summit Schedule this Week
Well, it is here folks. The PASSSummit 2013. If you have never been to a PASS Summit, please look in...
2013-10-14
610 reads
Networking Dinner at the 2013 PASS Summit–Tonight!
Tonight for the fourth year Steve Jones and I are hosting an informal networking dinner. We’ll be at Buffalo Wild...
2013-10-14
379 reads
PASS Summit 2013 Report #1
Yesterday we drove up from Charleston where I had attended SQLSaturday #227. It’s not a bad drive, about three hours....
2013-10-14
313 reads
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,139 reads
SSIS Tips and Tricks Q&A
Thank you to everyone who attended my webinar on SSIS Tips and Tricks on October 3, 2013. The link to...
2013-10-14 (first published: 2013-10-07)
3,668 reads
Top 11 Qualities of a DataWarehouse Implementer
Top 11th Quality: Curious to explore different designs There are many ways to achieve the same thing. Before actually getting...
2013-10-14
536 reads
Two Weeks to SQL Intersection
If you haven’t made it to a conference this year, you’ve still got a great one to think about: SQL...
2013-10-14
742 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