Can You Dig It? – StmtUseDb Element
She can dig it!
D Sharon PruittThe last post in the plan cache series discussed the children for the Statements element. ...
2010-12-21
675 reads
She can dig it!
D Sharon PruittThe last post in the plan cache series discussed the children for the Statements element. ...
2010-12-21
675 reads
Watching videos?! Su-ure!
Time for the second week of blogging about the things that I’m doing to study for the MCM...
2010-12-21
577 reads
She can dig it!
D Sharon PruittIn the last couple plan cache posts, I talked about a couple items that are...
2010-12-20
881 reads
Stinking Feet?
Want to learn some stuff about SSIS? Want to do it from the couch and not have to get...
2010-12-20
570 reads
Service Pack 4
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL...
2010-12-18
828 reads
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of...
2010-12-16
538 reads
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,345 reads
Onion Ring Buffer?
Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”? This request happened...
2010-12-15
737 reads
Go SQL! Go SQL! It’s the last day and the last chance (last dance?) to submit a session for the...
2010-12-15
697 reads
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,764 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers