PASS Summit Report #3
Started today with breakfast with the family after packing up all their clothes and stuffed animals for the trip home....
2013-10-15
430 reads
PASS Summit Report #2
Weather a bit cloudy today, a little rain and a little cool – not Seattle, but not Orlando either! Breakfast at...
2013-10-15
459 reads
SQL Server Diagnostic Information Queries for October 2013
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,331 reads
DMV-15 : Pending I/O requests……..sys.dm_io_pending_io_requests
sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx
Returns a row for each pending I/O request in SQL...
2013-10-15
1,398 reads
Attending the SQL PASS Summit?
Are you attending the SQL PASS Summit conference in Charlotte, NC this week? If so, let’s meet up! If not,...
2013-10-15
912 reads
SQL Server Performance Root Cause Analysis in 10 Minutes
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,120 reads
Monitoring Structure Changes
Most everyone I know works with environments that are carefully controlled and structured. All changes go through rigorous testing and...
2013-10-22 (first published: 2013-10-15)
2,308 reads
October 2013 – Monthly SQL Server Checklist
It’s not the first Monday of October, instead it’s the second Tuesday (oops, had Wednesday in here originally). As we...
2013-10-15
627 reads
Speaking about BIML at the SQL Server Days 2013
I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The...
2013-10-15
440 reads
Speaking about BIML at the SQL Server Days 2013
I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The...
2013-10-15
792 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...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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