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
700 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 Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Comments posted to this topic are about the item Cleaning Up the Cloud
Comments posted to this topic are about the item The Maximum Value in the...
Comments posted to this topic are about the item Oracle Performance Tuning: Practical Techniques...
I have a table with this data:
TravelLogID CityID StartDate EndDate 1 1 2025-01-01 2025-01-06 2 2 2025-01-01 2025-01-06 3 3 2025-01-01 2025-01-06 4 4 2025-01-01 2025-01-06 5 5 2025-01-01 2025-01-06I run this code:
SELECT IDENT_CURRENT('TravelLog')I get the value 5 back. Now I do this:
SET IDENTITY_INSERT dbo.TravelLog ON INSERT dbo.TravelLog ( TravelLogID, CityID, StartDate, EndDate ) VALUES (25, 5, '2025-09-12', '2025-09-17') SET IDENTITY_INSERT dbo.TravelLog OFFI now run this code.
DBCC CHECKIDENT(TravelLog) GO INSERT dbo.TravelLog ( CityID, StartDate, EndDate ) VALUES (4, '2025-10-14', '2025-10-17') GOWhat is the value for TravelLogID for the row I inserted for CityID 4 and dates starting on 14 Oct 2025? See possible answers