24 Hours of PASS, Fall 2012
It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...
2012-08-22
708 reads
It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...
2012-08-22
708 reads
I’m writing this Friday evening in Cleveland at the hotel, relaxing after the speaker dinner and getting ready for SQLSaturday...
2012-08-22
709 reads
I’m excited to be back on the speaking circuit. I was able to attend SQLSaturday #122 – Louisville thanks to Idera...
2012-08-22
745 reads
In our last post, we have gone through the data page structure and we have noticed that there is an...
2012-08-22
7,354 reads
Suppose you want to stop using a DDL trigger for a short period of time, such as the login trigger...
2012-08-21
6,381 reads
It’s been a year already and it’s time to head back to Kalamazoo for their SQL Saturday. We’re heading back...
2012-08-21
927 reads
Post-webcast update: The webcast went well! We talked, we QnA’ed, we gave out a free Roadmap, and all attendees got...
2012-08-21
830 reads
Auto-deploying AV definitions has become common place throughout the industry. However, this post from the SANS Internet Storm Center raises the...
2012-08-21
1,281 reads
It's been a while since I was in the day-to-day business of security patches. However, I still keep up with...
2012-08-24 (first published: 2012-08-21)
2,582 reads
I have been appointed as PASS Regional Mentor for the Greater Southeast by PASS (http://www.sqlpass.org). I am truly honored to...
2012-08-21
921 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