How to Remove (Undo) Table Partitioning
I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but...
2013-02-04 (first published: 2013-01-29)
8,857 reads
Blog Posts
I hate Windows 8 and Microsoft Top 3 Mistakes
What do you think about Microsoft new Operating System? I hate Windows 8! This is the answer that many people...
2013-02-04
1,018 reads
Last Weeks Top 10 “Reading” Links #18
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-02-04
497 reads
New DMO in Azure SQL Database: sys.dm_db_wait_stats
I just did a series of Boogle searches and when that didn’t find anything I tried Ging. Neither listed sys.dm_db_wait_stats....
2013-02-04
1,411 reads
SQL Saturday 220 Atlanta GA
That latest installment of SQL Saturday Atlanta was just announced. On May 18th 2013 SQL Server experts from all over...
2013-02-04
641 reads
SQL Server Analysis Services Tabular KPIs
A few weeks ago, I wrote a blog post that discusses implementing KPIs in SQL Server Analysis Services Multidimensional. For...
2013-02-04
2,635 reads
SQLSaturday #184 in New Haven, CT - March 2, 2013
So much SQL, and so little Saturdays. SQLSaturday is truly a world-class event
happening all over the globe. Just this
past Saturday,...
2013-02-04
1,257 reads
SSIS Webinar in 3 days... 6 seats left
Our first SSIS 1h Free webinar will take place in 3 days (Thursday) and has only 6 seats left (out...
2013-02-04
667 reads
Where Should Database Administration Go?
For the past 5 or 6 years, we have seen lots of innovative products emerged, from smartphone to tablets, from...
2013-02-04
796 reads
A Month of PowerShell – Day 3 (Security)
Welcome to Day 3 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-03
1,622 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