New Publications and a Video
The people at Webucator were kind enough to make a video based on my article on dealing with SQL Server...
2015-11-17
418 reads
The people at Webucator were kind enough to make a video based on my article on dealing with SQL Server...
2015-11-17
418 reads
Enable 32 bit Applications Azure Cloud Service Hosting automation
Sometime dll issues occured on IIS based on 32-bit or 64-bit dlls.Error...
2015-11-17
1,403 reads
I’ve been to the SQL Saturday in Washington, DC a few times and I’m looking forward to going back. It’s...
2015-11-16
729 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-16
411 reads
…so the job failed….again…you know the one – that darn Integrity Check job: Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp_ma...".: 100% complete ...
2015-11-18 (first published: 2015-11-16)
11,521 reads
Every time I install a new version of SSMS I make a handful of changes to the default setup. For...
2015-11-16
1,153 reads
Automatically name primary key constraints
There are some things you see when writing t-sql code and schemas that just look sloppy,...
2015-11-16
459 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look sloppy, one of those is unnamed constraints, what you...
2015-11-16
13 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
54 reads
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
39 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