Video: Introduction to SQL Server Change Tracking
SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For...
2016-11-25 (first published: 2016-11-18)
1,482 reads
SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For...
2016-11-25 (first published: 2016-11-18)
1,482 reads
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...
2016-11-18
1,102 reads
Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/
SQL Server 2016 SP1 has been released....
2016-11-18
434 reads
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,401 reads
Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made. Here is a summary of the...
2016-11-17
632 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-11-17
737 reads
Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are...
2016-11-17
896 reads
SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...
2016-11-17
732 reads
They finally did it! Finally SQL Server for Linux was announced. I’ve been waiting for this for quite a while, so...
2016-11-16
1,342 reads
SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better,...
2016-11-16
1,192 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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