SQL Server 2008 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-20 (first published: 2012-06-11)
3,078 reads
Glenn Berry
SQL Server 2012 RTM Cumulative Update 2
Last night, Microsoft released SQL Server 2012 RTM Cumulative Update 2, which is Build 11.0.2325.0. It has 37 fixes in...
2012-06-19
1,802 reads
Two New Cumulative Updates for SQL Server 2008 R2
Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. The first one is SQL Server 2008 R2...
2012-06-19
1,149 reads
SQL Server 2005 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-12
1,153 reads
SQL Server 2012 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-11
1,728 reads
Analyzing TPC-E Benchmark Performance by Physical Processor Core
The TPC Benchmark E (TPC-E) is an OLTP performance benchmark that was introduced in May, 2007. The TPC-E benchmark is...
2012-05-23
2,171 reads
SQL Server 2008 SP3 Cumulative Update 5 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...
2012-05-21
2,035 reads
Dell 12th Generation Server Cheat Sheet
Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use...
2012-05-16
2,255 reads
Speaking at Rocky Mountain Tech Trifecta 2012 on May 19
I will be presenting two sessions at the Rocky Mountain Tech Trifecta in Denver on May 19, 2012. This is...
2012-05-10
854 reads
SQL Server 2005 Diagnostic Information Queries (May 2012)
Even though SQL Server 2005 fell out of Mainstream Support back in April of 2011, I know many people are...
2012-05-08 (first published: 2012-05-04)
2,372 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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