Monday Morning SQL Break – January 4, 2016
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-04
446 reads
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-01-04
446 reads
SQL Server's buffer pool is a majority of your memory, but most DBAs can't tell you what's in it.
2016-01-04
31 reads
DBAs are known for asking for more memory, but often can’t say what’s in memory. While I agree that many...
2016-01-07 (first published: 2016-01-04)
2,788 reads
It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell...
2016-01-04
448 reads
Humans are creatures of habit, and I suspect that engineering/technical types are even more so. We find something that works...
2016-01-04
458 reads
I have a few gems that are available to you in the GUI. These gems should help solidify your understanding of the tools available through the GUI to help...
2016-01-02
8 reads
The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events....
2016-01-02
1,486 reads
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
21 reads
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and...
2016-01-01
482 reads
It’s the first day of the year 2016 and I’m thinking about all the SQL events I attended in 2015.
SQL Sat...
2016-01-01
549 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