Speaker Selection for SQLSaturday Orlando-Group #1
Today we’re starting to announce speakers that will have at least one session on the schedule for SQLSaturday #151 in...
2012-06-28
1,561 reads
Today we’re starting to announce speakers that will have at least one session on the schedule for SQLSaturday #151 in...
2012-06-28
1,561 reads
In my Encryption Primer talk, I do demo on symmetric key use, and wanted to document it here. Encryption is...
2012-06-27
3,031 reads
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality product that is new to SQL Server 2012. The...
2012-06-27
5,211 reads
Just a reminder: you have until this Friday to enter the 2012 Exceptional DBA awards. I’m judging, and looking forward...
2012-06-27
1,624 reads
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
9,461 reads
When I started writing this blog I realized it has been several months since my last post. I guess that...
2012-06-27
1,751 reads
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,614 reads
I ran across the following error in SQL Reporting Services 2008 R2 a few weeks ago:
The report execution has expired or...
2012-06-27
12,471 reads
One of my favourite things about the SQL community is the exquisite diversity of talent of it’s members. Today for the “What’s it...
2012-06-27
2,019 reads
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,448 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