Get All Referenced Tables and Columns
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...
2015-11-19
1,598 reads
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...
2015-11-19
1,598 reads
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...
2015-11-19
476 reads
Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When the message is greater than 8000 bytes, extra-characters will...
2015-11-19
44 reads
Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When...
2015-11-26 (first published: 2015-11-19)
1,777 reads
Three big things I look for in documentation:
Who to call when it goes wrongWhere to find it the code, especially...
2015-11-19
546 reads
Earlier this week I presented a free webinar for Pragmatic Works where I discussed how to migrate virtual machines to...
2015-11-19
1,336 reads
If you follow Grant Fritchey (B|T) at all, you know that every month he picks a “Speaker of the Month”....
2015-11-19
468 reads
Today we had a full-day event in Microsoft about the data offerings and possibilities in the Microsoft cloud platform – Azure....
2015-11-19
718 reads
This week’s #sqlnewblogger posts!
Author Post @eleightondick [[T-SQL Tuesday] Data modeling: The trouble with prefixes @tomsql Adventures With TomSQL, aka Tom Staab @EdDebug [Automatically name primary key constraints in SSDT...
2015-11-19
17 reads
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
695 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