Check out the latest and greatest...Great Value It Training Offers
Here's this weeks list of courses. At £750 plus VAT... I can't see how you can fail
1902: Linux Virtualisation 4...
2016-07-26
443 reads
Here's this weeks list of courses. At £750 plus VAT... I can't see how you can fail
1902: Linux Virtualisation 4...
2016-07-26
443 reads
Get SQL Server configuration, service info, start type along with enabled Trace Flags of local or remote servers.
This script outputs...
2016-07-26
613 reads
I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can...
2016-07-26
706 reads
Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on...
2016-08-01 (first published: 2016-07-26)
2,281 reads
I’ve had this idea for some time. It’s been bugging me, but I haven’t really been pressured to write, nor...
2016-08-05 (first published: 2016-07-26)
1,633 reads
This week is my fourth week on the spin being involved in a Learning Tree Course. This week we have...
2016-07-26
611 reads
I’m proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my forth SQLSaturday event this year and I’m really excited...
2016-07-25
16 reads
I’m proud to announce that I will be speaking at SQL Saturday Baton Rouge on August 6th 2016! This will be my...
2016-07-25
442 reads
When you feel you deserve to be an MVP, are you prepared to do more work? Being an MVP is not just an award - it is a commitment...
2016-07-25
11 reads
I have been sitting on this article for a while now. I have been tossing around some
thoughts and finally...
2016-07-25
567 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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