Availability Group on SQL Server 2016
The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...
2017-02-01
2,362 reads
The Challenge
One of our clients in the gaming industry wanted to set up a high availability solution in their data...
2017-02-01
2,362 reads
There are many cases where you will be using temp tables, and many of us are trying to seek for...
2017-02-01
6,973 reads
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,518 reads
I noticed that my backup was taking longer than usual. I went to Perfmon to look at some counters, more...
2017-02-01
830 reads
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
23 reads
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is taken from StackOverflow. Charted data looks like in...
2017-02-01
25 reads
I was curious about how the SQL language stands with the other technologies. Next table shows it. The data is...
2017-01-31
548 reads
This is the second article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON.
Part...
2017-01-31
32 reads
I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want...
2017-01-31
952 reads
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
754 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