March 2011 S3OLV Meeting Recap
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good...
2011-03-15
708 reads
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good...
2011-03-15
708 reads
The Las Vegas SQL Server Users Group met on March 10, 2011. The meeting was both virtual and in-person. Good news – we had just about as many person...
2011-03-15
1 reads
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking,...
2011-03-14
1,095 reads
As database professionals, we have a need to benchmark performance of the database, processes, and essentially overall performance. When benchmarking, it is preferable to get a baseline and then...
2011-03-14
1 reads
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a...
2011-03-10
2,824 reads
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one...
2011-03-10
9 reads
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form...
2011-03-09
1,033 reads
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form of recommendation requests for maintenance plans. As many already...
2011-03-09
1 reads
Data Size Collection and Analysis
By now you should be well acquainted with this phenomenon we call TSQL Tuesday. This party...
2011-03-08
675 reads
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
T-SQL Tuesday Participation Over the...
2011-03-08
1 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