My Partitioning And Compression Quest!
So I have a pretty big database (around 1 TB) that’s getting a bit out of
hand. I inherited it...
2011-05-03
658 reads
Blog Posts
T-SQL Tuesday #18 Coming Next Week
Other than the week I hosted it, I’ve been caught off guard by T-SQL Tuesday most months. This time I...
2011-05-03
689 reads
2011-05-02
8 reads
2011-05-02
5 reads
Checkpoints and the Lazy writer
Hi,
Both the lazy writer process and a checkpoint both push in-memory pages out to disk, however that’s where the similarity ends.
The reason...
2011-05-02
20,313 reads
Foreign Keys Help Performance
I have always put FKs into my database for data integrity purposes. I’ve worked on enough applications that didn’t have...
2011-05-02
1,256 reads
I’m an ACE
I am happy to announce that I’ll be joining Idera’s Advisor & Community Educator for SQL Server program.
Getting More Involved
I’ve always...
2011-05-02
491 reads
I’ve got 99 Problems, but a disk ain’t one
Tom LaRock has a new meme for Meme Monday. It’s all about the problems caused in your system other than...
2011-05-02
797 reads
Meme Monday – “I got 99 problems but a disk ain’t one”
Today is Meme Monday and is a little thing that Thomas LaRock (Blog | Twitter) has started. Today he has started things off with a list of things that...
2011-05-02
10 reads
Meme Monday – “I got 99 problems but a disk ain’t one”
Earlier today, Thomas LaRock (Blog | @SQLRockstar) tagged me for his Meme Monday post. The question for today is: how many...
2011-05-02
571 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers