Too many Foreign Keys
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
10 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
10 reads
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
111 reads
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,031 reads
I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:
As...
2016-03-15 (first published: 2016-03-09)
3,030 reads
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
810 reads
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
624 reads
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
608 reads
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
646 reads
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
534 reads
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
487 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