Using SQL Server Diagnostics (Preview)
I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What...
2017-06-27
592 reads
I was VERY excited when I read the following tweet (below) from Bob Ward regarding SQL Server Diagnostics capability. What...
2017-06-27
592 reads
The ability to export a script of database objects has for a long time been a feature of SQL Server...
2017-06-27
110 reads
Managing indexes is a critical component of database maintenance but we often don’t think about the indicators behind the index...
2017-06-26
593 reads
I had a strange situation the other day, where a number of things went wrong with my instance. First, I...
2017-06-26
725 reads
SQL Server provides multiple ways to perform most functions. In order to maximize your understanding of how SQL Server works...
2017-07-06 (first published: 2017-06-26)
2,024 reads
Brent Ozar (b/t) posted a pop quiz on twitter earlier today.
Go ahead and give it a shot .. I’ll wait.
So?...
2017-06-26
682 reads
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot...
2017-07-06 (first published: 2017-06-26)
1,428 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-06-26
259 reads
Join me Friday, July 21, 2017 for a day of Real-life SQL Server Performance Troubleshooting as part of SQLSaturday Columbus...
2017-06-26
727 reads
When I start talking with folks about security, one of the areas of confusion I often find has to do...
2017-07-05 (first published: 2017-06-26)
1,837 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