sqlservr.exe
We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...
2016-11-25
727 reads
We all know what the sqlservr.exe and its importance, but have you noticed the size difference of the .exe when comparing...
2016-11-25
727 reads
Recently I have been working on a project where I needed to parse XML files that were between 5mb and 20mb in size. Performance was critical for the project,...
2016-11-24
30 reads
This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes...
2016-12-01 (first published: 2016-11-24)
2,605 reads
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...
2016-11-24
1,776 reads
It’s Thanksgiving again here in the United States. Throughout the years, the IT community has been awesome. I have been...
2016-11-24
412 reads
AdvertisementsAlwaysON database not synchronizing mode SQL service account change
Suddenly, one of our alwaysON server databases are went not synchronizing mode.
Errors...
2016-11-24
2,616 reads
For this post I want to show you how I recovered to a LSN where I did do this on...
2016-11-24
647 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-11-23
666 reads
In this post I will show a procedure to configure Integration Services in a SQL Server 2016 Cluster.Clustering Integration Services is...
2016-11-23
598 reads
So you want to do some tuning, but you’re not sure how to test a query on it’s performance. Not...
2016-11-23
1,369 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