Reducing Your Storage Footprint Using SQL Storage Compress
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many...
2012-09-06 (first published: 2012-09-04)
1,915 reads
Capture SQL Server Deadlocks using Extended Events
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,540 reads
Am I Following Your Blog?
As I sat around this past weekend I was left wondering… am I missing any good blogs out there? With...
2012-09-03
902 reads
Quick T-SQL Performance Comparison
I’m not a T-SQL guru. When I have something that will run often, or I have performance concerns, I’ll ask...
2012-09-03
1,298 reads
How To Simply Say You’re a DBA
Have you ever looked back on a conversation where someone asked you “what do you do?” and felt disappointed with your reply?...
2012-09-03
984 reads
sp_helptext
My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...
2012-09-02
4,142 reads
Troubleshooting Oracle Link Server - Part2
It's my bad that I did not made a post since long lately. I would not make an excuse like...
2012-09-01
1,075 reads
Personal Goals
With fall quickly approaching, I thought this would be an ideal time to set some personal goals for the upcoming...
2012-09-01
1,531 reads
Demonstration of a simple dashboard created with the Tableau Software
Like I said on Twitter, here’s the post about the dashboard I created using Tableau, a BI visualization software. I’ve...
2012-09-01
1,883 reads
Thinking on Execution
I read a lot, one the most recent books is The 4 Disciplines of Execution which is, of course, about...
2012-08-31
1,552 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
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