SQL Server on Linux Series: Moving TempDB
In the last blog post, we added additional drives to the SQL Server machine so that we can scale out...
2017-08-16 (first published: 2017-07-27)
1,460 reads
In the last blog post, we added additional drives to the SQL Server machine so that we can scale out...
2017-08-16 (first published: 2017-07-27)
1,460 reads
Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best...
2017-07-27
45 reads
Introduction
In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large...
2017-08-14 (first published: 2017-07-27)
93,043 reads
During the process of building an Azure lab, I ran into a place where my cluster was not completely validated....
2017-07-27
537 reads
I’m a technical guy.
Thus – I love tools. They make stuff go.
Tools are great.
Except – as I wrote in my other post...
2017-08-10 (first published: 2017-07-26)
1,777 reads
Recently I presented an online session with the title “Working with Very Large Tables Like a Pro in SQL Server 2016”....
2017-08-14 (first published: 2017-07-26)
4,753 reads
Relational database management systems (RDBMS) such as SQL Server, Oracle, MySQL, and PostgreSQL use transactions to allow concurrent users to...
2017-07-26
174 reads
Assess your vulnerabilities before a system compromise brings it all down: just like what wasn't done early morning on Zhiggy's...
2017-07-26
839 reads
I was building some code the other day and kept getting problems in my deployment for a change. The deployment...
2017-08-15 (first published: 2017-07-26)
1,760 reads
Ever have this conversation?
Dev: Hey, can you help me? The performance on my application is terrible all of a sudden.
DBA:...
2017-08-11 (first published: 2017-07-26)
3,216 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