Analysis of DBA professionals salary’s 2017 using PowerBI
On the 5th of January, Brent Ozar (b|t) launched a survey on “Tell Us What You Make: The 2017 Data Professional...
2017-01-23
427 reads
On the 5th of January, Brent Ozar (b|t) launched a survey on “Tell Us What You Make: The 2017 Data Professional...
2017-01-23
427 reads
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,134 reads
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,054 reads
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
233 reads
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets...
2017-01-23
320 reads
One of the most common mistakes people make when writing T-SQL is using a function in the where clause, and...
2017-01-23
2,260 reads
SQL is pretty verbose compared to some languages. It's a pretty big disappointment that I have to type out select...
2017-01-23
498 reads
You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session...
2017-01-23
1,949 reads
This was a good meeting. About 50 attendees showed up at Nova (we use their space for joint meetings) to...
2017-01-23
384 reads
This page is a table of contents for for several new and forthcoming posts. I’m posting a series of excerpts...
2017-01-22
538 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