Advice for MAXDOP setting
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
20 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
20 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much on the forums and there are different recommendations...
2015-10-16
29 reads
This post is for the MAXDOP option – how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
234 reads
I am proud to be offering several training opportunities at the upcoming PASS Summit in Seattle, WA during the week...
2015-10-16
596 reads
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
465 reads
This post is for the MAXDOP option - how to set it in a SQL Server instance. The option is discussed much...
2015-10-16
906 reads
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-16
509 reads
In this article, I introduce the topic of reading session data from memory along with some of the pitfalls and some words of caution.
Related Posts:
How to: File Target use...
2015-10-16
32 reads
In the last few articles I took you through a progression of working with the event_file target from the most...
2015-10-20 (first published: 2015-10-16)
1,666 reads
I like writing go (golang not the batch separator) and one of the things that I like is that if...
2015-10-16
917 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