SQL Server 2016 – Stretch Databases
One of the feature I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-15
518 reads
One of the feature I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-15
518 reads
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
1,353 reads
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
490 reads
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want...
2015-04-27
895 reads
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want...
2015-04-27
320 reads
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
1,084 reads
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
411 reads
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
870 reads
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
465 reads
In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly?...
2015-04-10 (first published: 2015-04-06)
829 reads
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
By Steve Jones
One of the things I’ve been experimenting with in AI is taking things other...
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
We are in the process of upgrading to SQL Server 2022 and would like...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers