Wait Stats, Here and gone again?
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
510 reads
Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...
2017-04-05
510 reads
Since becoming a Database Administrator I’ve always looked at Microsoft MVP’s as the giants in our field. I never once...
2017-04-05
343 reads
If there’s one thing that SQL Server is really good at, it’s relationships. After all, a relational database management system...
2017-04-05
128 reads
Last night I had the privilege to present to the Ohio North SQL Server User Group about JSON in SQL Server 2016. There was a great crowd present (they...
2017-04-05
16 reads
If you’ve been involved in technology for any length of time you are aware of outside threats to your network...
2017-04-05
381 reads
I think SQL Clone is a useful, handy product. It’s what I’ve needed in a number of organizations, or it’s...
2017-04-05
653 reads
Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. No...
2017-04-05
510 reads
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
443 reads
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
182 reads
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
482 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