SQLFool IDX Defrag Scripts
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for...
2010-01-26
921 reads
SQL RNNR
Tweeting – I took the Dive.
In a previous post, I questioned how much Twitter could really do for me. After some comments made, and some...
2010-01-26
602 reads
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In...
2010-01-26
839 reads
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-23
1,075 reads
PayPeriod Matching
Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data...
2010-01-21
993 reads
Tweet, Tweet, Tweetilly Deet
In a day and age when information abounds and social networking is the only way to communicate (a bit of...
2010-01-19
523 reads
Leaving on a Jet Plane
Ok, so it’s not until November – but I am leaving on a Jet Plane nonetheless. It will have been four...
2010-01-18
551 reads
Presentations – Lessons Learned
This will be a very short entry. I just wanted to share a few things I learned very quickly while...
2010-01-15
863 reads
TSQL Tuesday – But I was Late
I was late to the game having discovered the Blog Post the day after entries were allowed. Despite that, I...
2010-01-14
826 reads
Primary Key Discovery II
In Part I, I discussed a couple of scripts that could be used to help discover some vital information about...
2010-01-13
635 reads
Blogs
Free SQL Practice: 9 Killer Resources to Boost Your Query Skills
So, you want to get your SQL skills razor-sharp without dropping any cash? You're...
DevOps Devour Hour Slides
By Steve Jones
Here are the slides from my talk today at the Redgate NYC Devour Hour:...
Advice I Like: Take Two Trips
By Steve Jones
If you have any doubt about being able to carry a load in one...
Forums
Analyzing Tempdb Spills and Usage Across Recursive Queries
Comments posted to this topic are about the item Analyzing Tempdb Spills and Usage...
Creating a new API in Data API Builder
Comments posted to this topic are about the item Creating a new API in...
Deadlocks and Backups - Need help
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Question of the Day
Creating a new API in Data API Builder
If I run "dab init" to create a new API over a database, what parameters are required?
See possible answers