Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax
After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...
2012-07-12
3,778 reads
After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...
2012-07-12
3,778 reads
I have several speaking events coming up, and I would love to see you there!
First of all, I'll be...
2012-07-11
1,069 reads
Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....
2012-07-11
1,328 reads
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say...
2012-07-11
19 reads
When was the last time you had to find something within your database? Did it feel more like a child’s...
2012-07-11
1,287 reads
If you're in or around the Midlands of South Carolina area, the Columbia Enterprise Developers Guild meets the 2nd Wednesday...
2012-07-11
961 reads
SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands...
2012-07-11
1,336 reads
Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...
2012-07-11
1,029 reads
Next week I will be speaking on designing your first Power View report for SQL Lunch. Be sure to join me...
2012-07-11
1,141 reads
Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...
2012-07-10
3,451 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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