Viewing RING_BUFFER_OOM Errors
Onion Ring Buffer?
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. ...
2010-12-15
1,349 reads
Blog Posts
Busy Week
It’s going to be a busy week for me. At last count, I had over 40 comments for my T-SQL...
2010-12-14
704 reads
Can You Dig It? – Missing Indexes
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
2010-12-14
2,770 reads
December PASSMN Meeting Today
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
Don’t forget, PASSMN meeting is today. As I’ve said before,...
2010-12-14
696 reads
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
2010-12-14
1,486 reads
Group Level Page Numbering using Reporting Services 2008 R2
Using SQL Server Reporting Services, we have always had the ability to use the built in fields (the Globals collection)...
2010-12-14
18,150 reads
Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)
One thing I have gotten wrong before, or not elaborated on during a past presentation on mirroring, although Roman Rehak mentioned...
2010-12-14
3,078 reads
Soft Skills Matter More Than You Think
Over my career I’ve seen interviews fall into three categories:
The technical part. Questions on trace flags, wait states, backups, etc,...
2010-12-14
612 reads
SQL Server 2008 Diagnostic Information Queries (Dec 2010)
I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse...
2010-12-14
667 reads
SQL Server Hardware Book
One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working...
2010-12-14
1,275 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers