Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,361 reads
Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,601 reads
Microsoft Hyper-V 2012 R2 Enhancements That DBAs Should Care About
The last couple of months have shown that the hypervisor battles for bigger, faster, and smoother are still heated and...
2013-10-02 (first published: 2013-09-26)
2,450 reads
SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,238 reads
PASS Votes
I’ve already made my own intentions clear. I’m casting one of my votes for Allen Kinsel. But, I get three...
2013-09-26
760 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
380 reads
Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
749 reads
Performance Tuning In LA!
Hello Dear Reader! This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta. Due to...
2013-09-26
549 reads
Which personal traits should a #SQLPASS Director have?
A lot has been said about what each candidate would like to do and their track record of delivering in...
2013-09-26
1,110 reads
I Just Voted in the PASS 2013 Election
I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...
2013-09-26
581 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