A quick note comparing ISNULL vs COALESCE
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,311 reads
There are hundreds of blogs that compare the T-SQL ISNULL function with the ANSI standard COALESCE function. There are also...
2016-10-13
1,311 reads
It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...
2016-10-13
485 reads
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
3,166 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-12
524 reads
I had a call with a customer this morning discussing different ways to publish Power BI content and how to...
2016-10-20 (first published: 2016-10-12)
1,127 reads
Update: 2017-07-14
Still find this incredibly awesome! Developer just updated for Visual Studio 2017 after a lot of hard work. Github...
2016-10-12
284 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What is it? A stretch database is basically a database...
2016-10-12
15 reads
SQL Server 2016 introduces Stretch Databases, a beautiful feature that by itself makes migrating to SQL 2016 worth it. What...
2016-10-12
235 reads
Faced with auditing SQL Server on a regular basis with no 3rd party tools? Where do you start? That’s what...
2016-10-12
452 reads
I love SQL Prompt, since it makes T-SQL coding quicker and easier. One of the handiest things is the Snippet...
2016-10-12
727 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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