Working With Compliance
Most larger and all publicly held companies will have some sort of compliance team – often a few varieties, ranging from...
2012-08-09
583 reads
Most larger and all publicly held companies will have some sort of compliance team – often a few varieties, ranging from...
2012-08-09
583 reads
UPDATE 2012-09-12 For my latest adventures with TSQL Parsers please see this post.
I’ve been doing a lot of work with the...
2012-08-09
1,997 reads
Summer is beginning to wrap up for those of us in the northern hemisphere and were finally to August. Maybe...
2012-08-09
1,156 reads
I saw this question posted the other day and thought it was a great idea.
I haven’t been a big...
2012-08-09
2,455 reads
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,562 reads
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,254 reads
This past weekend was SQLSaturday159 - Kansas City. I drove down with my wife and our sons (2 years old and...
2012-08-09
960 reads
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,512 reads
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,956 reads
I recently placed an order for a ThinkPad W530 from Lenovo. One day before the estimated shipping date, I noticed...
2012-08-09
3,398 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