Executing DBCC for SQL Server Analysis Services 2016
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...
2015-09-09 (first published: 2015-09-03)
2,117 reads
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...
2015-09-09 (first published: 2015-09-03)
2,117 reads
If you’ve read my blog for a while you may have seen the following posts:
Ten MDX Calculations For Your Cube...
2015-09-02
1,074 reads
I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my...
2015-09-01
785 reads
After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that...
2015-09-04 (first published: 2015-08-29)
4,420 reads
Power Pivot is an amazing, flexible and powerful business intelligence tool (among other things) and there is no doubt about...
2015-08-26
1,040 reads
Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...
2015-08-21
744 reads
The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool,...
2015-08-20
2,472 reads
The Scatter Chart in Power BI and Excel is very useful chart for visualizing three different metrics in tandem. But...
2015-08-28 (first published: 2015-08-19)
3,531 reads
With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query...
2015-08-15
1,170 reads
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful...
2015-08-12
1,154 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