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
Blog Posts
#TribalSQL: A new book by new voices in SQL Server
Two years ago, we were talking about how cool it would be to get a bunch of unpublished authors to...
2013-09-17
534 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
Debugging database mail issues in your SQL Server with T-SQL
Problem. Your database mail suddenly stopped sending out email notifications on completed jobs and tasks. You try to send out...
2013-09-17
1,115 reads
Don't Rush When It Comes to Privacy Data
The Dataloss list sent the following article through yesterday afternoon:
Obamacare Employee Accidentally Sends Out 2,400 Social Security Numbers
This is concerning,...
2013-09-17
2,231 reads
Encryption Decryption Routine
In this post we will look at a complete end to end routine for encrypting, storing, decrypting data in SQL...
2013-09-17 (first published: 2013-09-11)
3,937 reads
Geometry in the Cloud - where geospatial data meets the cloud.
Mount Olympus: Stratosphere: It was inevitable that two innovative technologies would merge to create a world of potential in the...
2013-09-17
1,570 reads
Great Idea: Tribal SQL
Writing books, even just a chapter, is not easy. Yet, people are desperate to do it for some reason. But,...
2013-09-17
850 reads
Guide to SQL Server Table Indexes – (Part 4)
Checkout the part-4 of my five part article series on Guide to SQL Server Table Indexeshere, in which you will learn...
2013-09-17
530 reads
Introduction to Integrity: Chain Linkage Problems
We’re approaching the end of our six part series Introduction to Integrity, sponsored by Idera with our last two postings...
2013-09-17
1,152 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