House Price Predictions @ PASS 2015
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
2 reads
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or...
2015-09-07
2 reads
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
9 reads
Originally appearing at ForITPros.com. Joe Webb’s father-in-law spent most of his adult life as a cardiologist. That’s a highly specialized and highly technical area in the field of medicine that...
2015-08-06
5 reads
Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader,...
2015-08-05
10 reads
Originally appearing at ForITPros.com. In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government...
2015-07-30
10 reads
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing...
2015-07-29
14 reads
2015-07-24
Originally appearing at ForITPros.com. Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.” That’s great insight. Too often...
2015-07-23
6 reads
Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available HERE, I described some of the findings contained in an intriguing new...
2015-07-22
8 reads
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
10 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 The Maximum Value in the...
Hi, it isnt clear from the web if something like this should work as...
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
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