T-SQL Tuesday #46: Rube Goldberg Machine
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL...
2013-09-10
450 reads
T-SQL Tuesday #46: Rube Goldberg Machine
It’s the second Tuesday of the month, and you know what time it is! That’s right, another installment of T-SQL...
2013-09-10
807 reads
T-SQL Tuesday #46 Rube Goldberg Machine aka Automating Deleting Older Certificates
Hello Dear Reader! This is the second Tuesday of the month and you know what that means, T-SQL Tuesday the...
2013-09-12 (first published: 2013-09-10)
1,774 reads
Introduction to Integrity: Corruption in Clustered Indexes and Heaps
For day three of this six part series Introduction to Integrity, sponsored by Idera, we will take a look at...
2013-09-10
1,233 reads
How to Avoid the 'Abuse' of SysAdmin by Applying User Defined Roles in SQL 2012 (and keep Exec.s and Auditors Happy)
This will not be a typical post, just a dive right away into Data Access Language Code, which provides a...
2013-09-10
3,755 reads
Good Advice on "Certification"
Buck Woody (blog | twitter) is often seen as one of the wise men of the SQL Server community and with...
2013-09-13 (first published: 2013-09-10)
2,646 reads
Monitoring Database and Table Sizes
Trending database and table sizes helps give you an idea of what to expect, and, sometimes, points out problems and...
2013-09-11 (first published: 2013-09-10)
4,142 reads
Las Vegas UG September 2013
Are you ready for some SQL? If you are like me, you are probably almost always ready for some SQL. Well, we have just what you are hungry...
2013-09-10
12 reads
Las Vegas UG September 2013
Are you ready for some SQL?
If you are like me, you are probably almost always ready for some SQL. Well,...
2013-09-10
690 reads
September 2013 – Monthly SQL Server Checklist
It’s the first Monday of September and it’s time to check up on your SQL Servers. In truth, it’s the...
2013-09-09
523 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