Database Lifecycle Management for Azure SQL Database
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,941 reads
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,941 reads
I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty...
2013-01-31
1,898 reads
In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project, you will now learn how...
2013-01-31
2,577 reads
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
437 reads
1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out
DECLARE @AGENT_ERRORLOG NVARCHAR(255)
EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,
N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,
N’ERRORLOGFILE’,
@AGENT_ERRORLOG...
2013-01-31
7,776 reads
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,863 reads
I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk...
2013-01-30
1,542 reads
We got a call last week about an application that was running slowly. The server was showing about 80% CPU...
2013-01-30
1,272 reads
This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a...
2013-01-30
1,502 reads
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,973 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