SQL RAP
Technorati Tags: SQL Nexus,SQLDiag,PSSDiag,PAL,SQL RAP,SQL Server 2012,SQL Server 2005,SQL Performance
About one year ago I had a Microsoft Premier Field Engineer...
2013-03-12
7,891 reads
Technorati Tags: SQL Nexus,SQLDiag,PSSDiag,PAL,SQL RAP,SQL Server 2012,SQL Server 2005,SQL Performance
About one year ago I had a Microsoft Premier Field Engineer...
2013-03-12
7,891 reads
I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with...
2013-03-18 (first published: 2013-03-12)
5,104 reads
Let’s start with a quick review of the pieces and what I paid:
ItemCostAntec P280 Case$90 (may be higher now)ASUS P8Z77-V...
2013-03-12
673 reads
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...
2013-03-19 (first published: 2013-03-12)
2,826 reads
T-SQL Tuesday #40 is underway, and this month's host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup...
2013-03-15 (first published: 2013-03-12)
2,914 reads
I had some sales reports that were running poorly on SQL 2005 Analysis Services. The information on the reports was...
2013-03-12
693 reads
On the weekend of the 9th March 2013, the second SQL Saturday in the UK occurred. A massive thank you...
2013-03-12
672 reads
It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with...
2013-03-12
1,351 reads
Backstory Each month the SQL community comes together for an important party. This is the blog party that was the brain child of Adam Machanic (Twitter) known as T-SQL Tuesday....
2013-03-12
21 reads
Backstory
Each month the SQL community comes together for an important party. This is the blog party that was the brain...
2013-03-12
1,087 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