AlwaysOn – Finally, A usable ‘mirror’! In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not...
2013-04-10
11 reads
AlwaysOn – Finally, A usable ‘mirror’!
In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are...
2013-04-10
868 reads
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-04-09
971 reads
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-16 (first published: 2013-04-09)
13,272 reads
Hello Dear Reader! It’s been a while since I participated in a T-SQL Tuesday, and this month Bob Pusateri (@SQLBob|Blog)...
2013-04-19 (first published: 2013-04-09)
1,362 reads
This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting. T-SQL Tuesday is a monthly blogging event where a number...
2013-04-09
573 reads
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...
2013-04-09
1,160 reads
Well sort of…it took a while.
I’d done some plays and singing at school but my mother made me practice...
2013-04-09
871 reads
It’s time for our monthly blogging party, commonly known as T-SQL Tuesday. This month, Bob Pusateri is providing the motivation...
2013-04-09
601 reads
Sometimes the answer is to keep going.
Forget words, figuring things out, and circumstances. Just keep moving your feet.
~Chuck
"Nothing in the...
2013-04-09
626 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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