SQL Azure, Hekaton, and Bob Dorr is Awesome
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...
2016-08-29
948 reads
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In...
2016-08-29
948 reads
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release.This isn’t just a collection of...
2016-08-29
16 reads
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and...
2016-08-29
1,945 reads
There has been a long standing debate over the use of a natural primary key vs an artificial one. I...
2016-08-29
1,331 reads
Index Utilization Report
One day my manager came and told me that he need Index Utilization Report.
He felt that during...
2016-08-29
583 reads
The SQL Server whenever it restarts all the databases goes into the recovery mode. In this state the database comes...
2016-08-29
11,817 reads
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
183 reads
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the...
2016-08-29
546 reads
Remote server management is a fact of life for folks involved with sql server. Since we work so often with...
2016-08-29
670 reads
I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live!
Do...
2016-08-28
613 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