Tips to improve your blog, really!
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...
2012-05-17
919 reads
As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought...
2012-05-17
919 reads
http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx
2012-05-17
28 reads
NELL (Never Ending Language Learning) is a computer system that is trying to learn to read the web. Couple things...
2012-05-17
721 reads
http://download.microsoft.com/download/B/E/1/BE1AABB3-6ED8-4C3C-AF91-448AB733B1AF/SSRSKerberos.docx
2012-05-16
218 reads
http://www.flickr.com/photos/shuck/3971270079/
Tonight I will be live in front of my home town crew at MagicPASS, lead by the one and only...
2012-05-16
696 reads
A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...
2012-05-21 (first published: 2012-05-16)
3,158 reads
I’m happy to say that for most of you out there, the answer to this question is “no.” That’s as...
2012-05-16
835 reads
Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic.
For...
2012-05-16
571 reads
Many of you may now or in the future have the need to upgrade your SSIS packages to the new...
2012-05-16
26,090 reads
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...
2012-05-16
827 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