Denali – Day 26: Tool: Power View- Reporting Power View (Aka Crescent)
Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent) If you are good with: Xls Pivot table Power...
2012-05-26
1,081 reads
Denali – Day 26: Tool: Power View -Reporting Power View (Aka Crescent) If you are good with: Xls Pivot table Power...
2012-05-26
1,081 reads
I have 2 upcoming speaker opportunities in June and am very excited about presenting this material.
June 9th is in...
2012-05-26
767 reads
This article about exercising when you can is really interesting. It contains a number of hints about exercising and fitting...
2012-05-25
1,177 reads
Here is a simple query which can list backup duration statistics for all database, including the max, min, avg of...
2012-05-25
2,815 reads
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
817 reads
I’m fond of replying with “done” when a task is complete, no need for anything more elaborate. I’ve been experimenting...
2012-05-25
595 reads
This idea came up during a critique of a presentation. I may have re-invented (or re-labeled) something that is already...
2012-05-25
633 reads
Denali – Day 25: Tools: Add-on to Sql server 2008 (R2)
MDS and Best Practice Analyzer new features were introduced in sql...
2012-05-25
710 reads
Recently developed these queries to assist with the evaluation of development or sandbox environments. Sometimes disk space demands that old...
2012-05-24
1,609 reads
There’s a lot to be said for the philosophy of Never Eat Alone, using meals as a great time to...
2012-05-24
769 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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