Developer’s Life – Every Developer is a Spiderman
Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero. The most...
2014-05-17
774 reads
Originally posted on Journey to SQL Authority with Pinal Dave:
I have to admit, Spiderman is my favorite superhero. The most...
2014-05-17
774 reads
Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...
2014-05-11
864 reads
Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally...
2014-05-10
1,518 reads
Problem : In most of your projects, there is always that situation that the application team have that need to run...
2014-05-10
664 reads
Problem: You had just finished up installing cluster setup in your Primary node. After verifying your setup is complete and...
2014-04-27
809 reads
Here’s a link for the download for the CU #16 for SQL2008 SP3 http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx. The post also includes all the previous...
2014-03-31
1,274 reads
Understanding CXPACKET From the SQL BOL (Books on Line) CXPACKET is defined as Class Exchange Packet and “occurs when trying...
2014-01-21
1,242 reads
The Copy_Only option is very useful in full backup scenario when you don’t want to break up the sequence of...
2014-01-08
1,059 reads
Wow, my first article for the year 2014! Here’s to a blessed and fruitful year ahead for all of us...
2014-01-08
686 reads
Originally posted on SQL DBA learning curve:
Hi ALL, for setting up TEST env for Server 2012 and above refer to...
2013-12-24
706 reads
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
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...
Comments posted to this topic are about the item Lessons from the Postmark-MCP Backdoor
Just saw the "Azure Extension for SQL Server" Does anyone has experience with it?...
I've noticed several instances of what looks like a recursive insert with the format:...
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