SQL Server 2008 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-18
1,081 reads
Blog Posts
SQL Server 2008 R2 SP2 Cumulative Update 4
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 4, which is Build 10.50.4270. I count 34...
2012-12-18
2,854 reads
SQL Server 2012 Cumulative Update 5
Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public...
2012-12-18
1,851 reads
You Need to Manage Passwords
I saw a note this week from CNet about a system built to crack passwords (also on ArsTechnica). It reminded...
2012-12-18 (first published: 2012-12-12)
2,736 reads
Annual Email Pruning
Like most of us, I get a lot of email. I get subscribed to various services from different ads, events,...
2012-12-17
965 reads
Are You a Chessplayer?
I was having a twitter coversation with @dataartisan about chess. He remarked that playing on-line with random folks didn't strike him...
2012-12-17
1,042 reads
CPU Overcommitment and Its Impact on SQL Server Performance on VMware
In the early days of virtualization, the core focus of virtualization was primarily consolidation. You could achieve quite high consolidation...
2012-12-17
1,941 reads
Generating multiple SQL statements from a query
Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can...
2012-12-17
1,154 reads
Ghost Cleanup process
I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog....
2012-12-17
14,028 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation
I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec...
2012-12-17
790 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