Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2016-03-11
832 reads
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2016-03-11
832 reads
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-03-11
472 reads
I’ve seen tables that are referenced by many other tables in MSSQL databases and that number was usually being around...
2016-03-10
129 reads
Different ways to get the size of the data , log files and Databases
Using CountersQuerying sysaltfiles & sys.databasesQuerying sys.master_files
SELECT instance_name AS DatabaseName,
[Data...
2016-03-10
1,119 reads
The cloud is calling to you. Or more specifically, Jody Roberts (b | @) and I (b | @) are looking to the community...
2016-03-10
375 reads
In case you missed it, back in November I blogged about the importance of nominating individuals within the SQL Server...
2016-03-10
394 reads
Hey, I need sysadmin access to ServerA.
Ok. Why do you need sysadmin?
Well I need to be able to read and...
2016-03-16 (first published: 2016-03-10)
2,328 reads
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism for AlwaysOn Availability Groups. Check out the many new...
2016-03-10
23 reads
In my opinion one of the key features of SQL Server 2016 is the rebuilt and optimized log redo mechanism...
2016-03-16 (first published: 2016-03-10)
1,826 reads
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar....
2016-03-10
23 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