First Presentation – Post Mortem
So it is done, it being my first presentation at a professional event. As you may recall, I recently presented...
2013-09-18
334 reads
The Dangers of Detach
I ran across a twitter conversation about a post recently. The post talks about detaching or attaching databases in bulk....
2013-09-18
1,121 reads
sp_DBPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,472 reads
sp_SrvPermissions V2.0
Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The...
2013-09-23 (first published: 2013-09-18)
2,098 reads
Finding Ad Hoc Queries with Query Hash
I was presenting a session on how to read execution plans when I received a question: Do you have a...
2013-09-20 (first published: 2013-09-18)
3,424 reads
Brad Shultz's blog on reviewing your database
Reblogged from SQL Studies: This is possibly the best blog I have every read on the subject of reviewing a...
2013-09-18
641 reads
CIO Report; 14 things you need to know about Data Storage Management
Reblogged from Imtech ICT UK Blog: Original Article: CIO recently published a detailed article on the 14 things you need...
2013-09-18
659 reads
Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012
Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket...
2013-09-20 (first published: 2013-09-18)
5,571 reads
Cumulative Updates - SQL Server 2012 SP1 CU6
As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #6.To apply this cumulative update package, you must be running SQL...
2013-09-18
29 reads
Brad Shultz’s blog on reviewing your database
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty,...
2013-09-17
715 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...
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