T-SQL Tuesday #36 – Community
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
738 reads
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
738 reads
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...
2012-10-21
8,198 reads
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,740 reads
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,338 reads
Late last year, my life got strange. Well, it’s always been strange, so let’s just say it became stranger than...
2012-07-18
753 reads
The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...
2012-06-25
691 reads
Lately, I’ve been asked by several folks about the interview questions that I use when I interview candidates for SQL...
2012-06-15 (first published: 2012-06-11)
12,023 reads
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,501 reads
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...
2012-04-19
3,316 reads
This month, T-SQL Tuesday is being hosted by Nigel Sammy. Since the RTM of SQL Server 2012 just occurred, he...
2012-04-10
1,628 reads
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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