Images, charts, indicators and sparklines in a tablix stretch and degrade report performance
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
380 reads
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
380 reads
This fact is probably not documented very well but this is an important factor in SSRS visual report design… The...
2013-09-26
749 reads
Hello Dear Reader! This year Pragmatic Works has brought our Performance Tuning Workshop to Chicago, Boston, and Atlanta. Due to...
2013-09-26
549 reads
A lot has been said about what each candidate would like to do and their track record of delivering in...
2013-09-26
1,110 reads
I feel like it’s been a good election cycle. Good set of candidates, good discussions, lots of good blog posts...
2013-09-26
581 reads
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...
2013-10-01 (first published: 2013-09-26)
1,675 reads
For the fourth year Steve Jones and I are hosting an informal networking dinner on Monday night at the PASS...
2013-09-27 (first published: 2013-09-25)
1,045 reads
I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at...
2013-09-25
615 reads
While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...
2013-09-25
1,327 reads
It’s that time of the year again – time to make your voice heard as a PASS member. The PASS board...
2013-09-25
884 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers