Thirty Hours at Home
This is a busy travel week for me, and one of those times that stresses out everyone in the household....
2013-04-08
724 reads
This is a busy travel week for me, and one of those times that stresses out everyone in the household....
2013-04-08
724 reads
Filtered index is a new feature introduced in SQL Server 2008. All the indexes that we have discussed till now...
2013-04-08
6,212 reads
Hey Friends,
It’s been a long time , I was out of touch with my blogs. But thanks to all for checking...
2013-04-08
982 reads
Restoring databases to a set drive and directory
Introduction
Often people say that necessity is the mother of invention. In this case...
2013-04-08
905 reads
sys.dm_exec_cached_plans DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-us/library/ms187404.aspx
Returns a row for each query plan that is cached...
2013-04-08
835 reads
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...
2013-04-07
341 reads
According to Wiki, Procedural Justice (PJ) means:
Procedural justice is the idea of fairness in the processes that resolves disputes and...
2013-04-07
769 reads
TweetG’day,
As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open...
2013-04-07
5,207 reads
Today I had the privilege of working with a great bunch of folks to help coordinate and host Omaha’s second...
2013-04-06
862 reads
Hello Dear Reader!
A quick note I'm presenting today at 1:30 pm for SQL Saturday Boston #203.
I'll be giving my...
2013-04-06
479 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