Recompile Monitoring using XEvents
Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it...
2016-03-17 (first published: 2016-03-07)
1,675 reads
Recompiles can be a hidden bottleneck on your server, and it may not be too obvious. I should know, it...
2016-03-17 (first published: 2016-03-07)
1,675 reads
Hey there!
This one is for those Exchange admins who think it is a sin to use hands for something that...
2016-03-06
801 reads
When you configure a SQL Server instance on a server, you have to consider the following ports:SQLServer default instance port...
2016-03-05
155 reads
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
511 reads
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
15 reads
When you configure a SQL Server instance on a server, you have to consider the following ports: SQL Server default instance port – 1433 Dedicated Admin Connection and SQL...
2016-03-05
19 reads
When you configure a SQL Server instance on a server, you have to consider the following ports:
SQL Server default instance...
2016-03-05
93 reads
I’ve written a few scripts and programs lately, mostly just for fun. In those scripts, I’ve used Write-Host to return...
2016-03-04
1,640 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2016-03-14 (first published: 2016-03-04)
1,726 reads
I’m finally getting back out to community events so I should be able to avoid giving this gigantic honor to professional...
2016-03-04
412 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