Querying and Optimizing DAX
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
4,019 reads
sp_spaceused system-stored procedure
You can use the sp_spaceused system-stored procedure to return space usage information about a database or a table within a...
2013-01-02
1,537 reads
SQLBits XI: Need Your Vote
SQLBits XI: Need Your Vote
SQL Bits XI
SQLBits XI is in Nottingham, U.K., May 2 – 4, 2013, and I am attending....
2013-01-03 (first published: 2013-01-02)
1,044 reads
Re-Awarded as a Microsoft MVP
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,202 reads
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
31 Days of Disaster Recovery
Welcome to my...
2013-01-04 (first published: 2013-01-01)
2,310 reads
VCAP5-DCA study guide is now available
Paul Grevink has released a great study guide for the VMware VCAP5-DCA exam. It’s available here! I’ll be using it...
2013-01-01
729 reads
Re-awarded MVP status for 2013
I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this...
2013-01-01
515 reads
Re-awarded MVP status for 2013
I received notification that I have received the Microsoft MVP award for 2013, my fourth consecutive year to receive this...
2013-01-01
656 reads
Looking Forward to the New Year - Professional Goals
Most folks make New Year's resolutions of things they want to do over the course of the next 364/365 days....
2013-01-01
1,317 reads
My 2012 Year
What a wild year this has been. There have been ups and downs, but the ups have been incredible. To...
2013-01-01
938 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