Modulo!
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...
2016-04-14
517 reads
I love this somewhat obscure mathematical operator. All it does is return the remainder of a division statement but even...
2016-04-14
517 reads
When you use the msdb tables to try to gather information on your SQL Server Agent jobs, inevitably you will...
2016-04-21 (first published: 2016-04-14)
4,227 reads
The function getDBs() function returns all the database list
db.getMongo().getDBs()
The runCommand is a special type of query called a database command and...
2016-04-13
585 reads
See you tonight for our special SQL Jeopardy! competition where I will be your Trebek and three lucky user group...
2016-04-13
412 reads
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow...
2016-04-22 (first published: 2016-04-13)
2,161 reads
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,057 reads
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life...
2016-04-13
17 reads
The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know...
2016-04-13
798 reads
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,023 reads
If you wish to build your own .NET application that allows the user to take database schema snapshots on demand or schedule them to be taken at certain times,...
2016-04-12
17 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