SQLSat 235 Wrap-Up
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for...
2013-09-03
787 reads
My Next Phone May Be a Nokia
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
551 reads
The Case of the NULL Query_Plan
As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...
2013-09-06 (first published: 2013-09-03)
3,284 reads
Good Intro Podcast on Hadoop
Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...
2013-09-09 (first published: 2013-09-03)
2,117 reads
Actual Emails: TL;DR: Stop using varchar(max)
Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich...
2013-09-05 (first published: 2013-09-03)
3,232 reads
SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,677 reads
SQL Server: Data File Structure
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about the organization of the data file.In other words...
2013-09-03
848 reads
Sending Mail using SQL Server Express Edition
In SQL server standard and enterprise edition,A DataBase mail functionality in built to sent mail.But in SQL Server express edition,You...
2013-09-02
65,535 reads
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification series at Microsoft joined the ranks of...
2013-09-02
14 reads
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification...
2013-09-02
1,223 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