Last Weeks Top 10 “Reading” Links #10
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-12-10
768 reads
Blog Posts
Management Studio Database Diagram Owners
If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio...
2012-12-10 (first published: 2012-12-03)
3,298 reads
Partitioning Table in SQL Server:
Partitioning Table in SQL Server: When your database has large tables. Then partitioning will be beneficial
in terms of performance, scalability and maintainability....
2012-12-10
1,344 reads
Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I'm running
on January 29 (Vienna/Austria) and January...
2012-12-10
2,458 reads
Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I’m running on January 29 (Vienna/Austria) and...
2012-12-10
1,210 reads
Reporting Services 2012 BI Training
Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert...
2012-12-10
1,540 reads
SQL Server Books–Query Tuning
Last week I was delivering a SQL Server Training course for learning tree. The course was 2109 SQL Server Virtualization...
2012-12-10
1,058 reads
T-SQL Tuesday Topics
An Updated list of all the topics.
I was looking for a static list of all the T-SQL Tuesday topics and...
2012-12-10
1,619 reads
Is Self-service BI Threatening IT Professionals’ Livelihoods?
(this is another follow-up to Chris Webb’s post on “Why Corporate BI and Self-Service BI Are Both Necessary”) There is...
2012-12-09
839 reads
SQL Saturday #173 Washington DC wrap up
Today I spoke at the Washington DC SQL Saturday #173. I first spent some time in the SQL Server Performance...
2012-12-09
740 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
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