SQL 2016 – Clone Database with Query Store
This is a quickie post to introduce the new DBCC command CLONEDATABASE.
Okay so this isn’t technically a SQL Server 2016...
2017-03-31 (first published: 2017-03-20)
2,378 reads
This is a quickie post to introduce the new DBCC command CLONEDATABASE.
Okay so this isn’t technically a SQL Server 2016...
2017-03-31 (first published: 2017-03-20)
2,378 reads
I’ve spent a lot of time browsing and participating in online technical forums. In my early years in the industry...
2017-03-28 (first published: 2017-03-20)
1,896 reads
In this post am going to introduce into some of the basic principles of probability – and use it in other posts...
2017-03-30 (first published: 2017-03-20)
4,535 reads
In a previous post I wrote about how easy it was to restore a whole SQL Servers user databases from...
2017-03-20
1,042 reads
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
325 reads
All the good DBAs backup their databases.
A significant amount of SQL DBAs use Ola Hallengrens maintenance solution to do so.
This...
2017-03-29 (first published: 2017-03-18)
3,074 reads
By David Postlethwaite
David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...
2017-03-18
735 reads
I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register...
2017-03-17
513 reads
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
895 reads
SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to...
2017-03-17
2,557 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers