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
Blog Posts
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
575 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,612 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
680 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,388 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
623 reads
SQL Server Locking & Block Scripts
A couple of weeks ago, I gave a presentation to the PASS DBA Virtual Chapter on SQL Server Locking & Blocking...
2010-03-08
551 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers