SQL Server 2012 AlwaysOn & A Thorough Setup
It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...
2012-03-14 (first published: 2012-03-12)
3,172 reads
Double-Dash Comments, the Hidden Menace
While writing my last post on cleaning up old maintenance plans, I was reminded of something I heard in a...
2012-03-12
2,591 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,932 reads
Cleaning up Old Maintenance Plans
This is something I trip over every now and then on systems we inherit from our clients, and I thought...
2012-03-12
691 reads
SQL Server 2012 RTM–Are you waiting for SP1?
As you probably know by now SQL Server 2012 was launched last week, Microsoft had an online launch event that...
2012-03-12
3,495 reads
Synchronizing subscriptions in SQL Server Express
I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...
2012-03-13 (first published: 2012-03-12)
4,345 reads
Jedi Mind Tricks
Here’s a story from a recent meeting. We were discussing some problems and the team was talking through some options...
2012-03-12
803 reads
Factors that can delay Log Truncation – LOG BACKUP
When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs...
2012-03-12
1,292 reads
March #Meme15 Assignment
This month, the #meme15 post will fall on March 15th, often referred to as the Ides of March. This date...
2012-03-11
666 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-11
10,027 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