Don't Use Delimiters In Your Object Names!
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,298 reads
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,298 reads
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
542 reads
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...
2016-04-04
655 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-04-04
467 reads
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
487 reads
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
7,664 reads
Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too....
2016-04-04
533 reads
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-04
228 reads
One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then...
2016-04-03
17,874 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-03
477 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