Fix for Blurry SSMS in Windows 10
I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a...
2017-08-14
7,783 reads
I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a...
2017-08-14
7,783 reads
So the decision to move to the cloud has been made but there is a fear from people that once...
2017-08-25 (first published: 2017-08-14)
937 reads
Nice to be back after a week off. I’ve been writing three posts a week (sometimes more) since the beginning...
2017-08-14
360 reads
Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we...
2017-08-13
356 reads
Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed...
2017-08-12
592 reads
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.With this third post I'll keep answering the question Where did...
2017-08-11
9 reads
These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend...
2017-08-11
1,462 reads
SQLskills is giving away free training for their performance tuning and optimization classes. My entry for the competition is below. If you decide to enter for yourself, entries are...
2017-08-11
17 reads
Welcome back, thanks for keep on reading me, and for the ones who read for the first time, welcome.
With this...
2017-08-11
192 reads
Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...
2017-08-11
1,366 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