SQL Server 2012 CU2 – Have a little fun (#AppliedSQL)
SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!
But there are actually...
2012-06-20
1,300 reads
SQL Server 2012 Cumulative Update (CU) 2 is out! If you’re like Me-from-10-years-ago, you couldn’t care less!
But there are actually...
2012-06-20
1,300 reads
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,115 reads
and your old clients too.
Before I started my contracting business five years ago I realised the importance of selling and...
2012-06-20
845 reads
An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was...
2012-06-20
774 reads
I wish I could say that this was a simple task, but as I dove into SMO and some of...
2012-06-19
2,765 reads
The fourth segment in this series focuses on using XMLA to deploy databases. When you create SQL Server Analysis Services...
2012-06-19
912 reads
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. The first one is SQL Server 2008 R2...
2012-06-19
1,149 reads
I’ve recently been asked for some clarification about this statement (from my last blog post): “This is EXACTLY the kind...
2012-06-19
782 reads
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
794 reads
I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped...
2012-06-19
1,248 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