2012 PASS Elections Letter Of Recommendation From Ed Watson
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
1,050 reads
2012 PASS Elections Letter Of Recommendation From Stacia Misner
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
676 reads
Windows Server 2012 and Hyper-V
I recently went to a Microsoft event in Denver on Windows Server 2012 and Hyper-V improvements. Harold Wong (b | t)...
2012-10-11
1,378 reads
2012 PASS Elections Letter Of Recommendation From Jes Borland
I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes...
2012-10-11
645 reads
Do you Dream?
You ever have those nights consumed by all things SQL? I do. It happens more than I might like sometimes. Usually it happens when there is a work problem...
2012-10-11
13 reads
Do you Dream?
You ever have those nights consumed by all things SQL?
I do. It happens more than I might like sometimes. Usually...
2012-10-11
943 reads
SQL Server : Index Part 1 : Basics of index
While conducting interviews , I have noticed that, many people does not have clear picture about index.Many of them does not...
2012-10-11
1,393 reads
Find Duplicate (and covered) Indexes
A while back, I wrote a simple little query that lets you Get Index Included Column Info (because sp_help and sp_helpindex only...
2012-10-11
1,686 reads
Interacting with Master Data Services (MDS)
There are four different way to interact with Master Data Services (MDS) to do things such as create a model, load...
2012-10-11
3,152 reads
Lost in Translation – Deprecated System Tables – sysfilegroups
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-11
784 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers