Viewing 12 posts - 1 through 12 (of 12 total)
I get an error running this query from the article:
ALTER DATABASE [database_name]
SET PARAMETER_SENSITIVE_PLAN_OPTIMIZATION = OFF;
Msg 102, Level 15, State 6, Line 2
Incorrect syntax near...
August 8, 2023 at 9:23 pm
I'm going to call my answer of "We can't guess" correct. The reason being, without knowing the structure of your table, we cannot possibly know the output of the INSERT...
July 31, 2023 at 9:50 pm
@Jonathan AC Roberts
What is it that you are wondering about in this regard?
That is the comment I was trying to reply to. In the last example, you are talking...
March 28, 2023 at 9:20 pm
It seems that the author made a mistake in the last example presented, because in the text he is talking about a view, but the example given is for the...
March 27, 2023 at 5:28 pm
"Single database, elastic pool, and Hyperscale" is listed as the correct answer, but I believe it should have been just "single database and elastic pool?
It even says that in the...
January 31, 2022 at 4:01 pm
Thank you!
November 17, 2020 at 4:58 pm
How do I determine if there are already objects accidentally in master?
November 12, 2020 at 11:11 pm
Theoretically, these clustered indexes usually have a hotspot on left or right side of the index tree. That hotspot can reduce speed of inserts on a busy system.
What...
December 27, 2018 at 11:53 am
It pains me to say it, but the most important (and therefore highest paid) people are not programmers or sales, but marketing. You can have the most technically superior product...
February 17, 2012 at 1:30 pm
@lowell - what is the value of "max"? In SQL Server 2000 I get an "Incorrect syntax near (max)" error.
ETA: I'm also getting this error - "'schema_name' is...
January 20, 2012 at 1:49 pm
Andy,
The article says it is Part 3 of a 4 part series. But there are no links (as is usually the case) to Part 1 & 2. I'd be interested...
February 9, 2007 at 10:45 am
Viewing 12 posts - 1 through 12 (of 12 total)