T-SQL Tuesday – I/O Fallacies
It’s time for the March T-SQL Tuesday and this month Mike Walsh picked the topic. It’s I/O and you can...
2010-03-09
467 reads
Blog Posts
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
This blog entry is participating in T-SQL Tuesday #004, hosted this month...
2010-03-09
1,463 reads
TSQL Tuesday #4: IO
“IO IO, It’s off to disk we go!” was in Mike Walsh’s blog post that introduced this TSQL Tuesday and...
2010-03-09
576 reads
Using a CTE with a T-SQL Pivot Statement
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a...
2010-03-09
9,614 reads
A Swing and a Miss by PASS
On Saturday my son had his second baseball game. When it was his turn to hit I reminded him to...
2010-03-08
572 reads
It’s Like the MVP Summit
I missed the 2010 MVP Summit, which is disappointing. There were a lot of SQL 11 talks and I was...
2010-03-08
421 reads
MacGyver?
Who the heck is MacGyver? Television program you say? Hang on. I need to visit imdb.com…
Oh, the late eighties… Yeah,...
2010-03-08
681 reads
Notes from SQLSaturday #33
I did the relatively quick flight to Charlotte on Friday afternoon, arriving just before 2 pm, grabbed lunch to go...
2010-03-08
303 reads
OPASS March Meeting with David Pless
March 9 6-8:30pm
This month's meeting sponsored by
Live Meeting: https://www.livemeeting.com/cc/usergroups/join?id=QFG3GW&role=attend
Speaker: David Pless
David has been a Senior Premier Field Engineer with...
2010-03-08
1,389 reads
Powershell- Is it easy as everyone claims?
Where ever you read, people claim that power shell is so easy that even a dummy can do it. Really?...
2010-03-08
625 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers