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
677 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
677 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
578 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
884 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
837 reads
Go SQL! Go SQL! Since I mentioned the SQLRally Call for Presenters, I figured I should also be one of...
2010-12-16
539 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,347 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
739 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
701 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
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Can/Can't Do/Don't
Comments posted to this topic are about the item Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers