ChrisM@Work

Forum Replies Created

Viewing 15 posts - 451 through 465 (of 10,143 total)

RE: SQL Server Last 30 days Not updated Statistics Stat

Appears to be a very close copy of this, which was published in 2012.
https://www.sqlskills.com/blogs/erin/new-statistics-dmf-in-sql-server-2008r2-sp2/
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2018 at 4:44 am

#1976296
RE: SQL Server Unused Index Script

This one is also stolen. The entire introductory text has been lifted word for word from the original.
It's on his LinkedIn too. What a B@$¬@~#.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2018 at 4:35 am

#1976294
RE: Find Most Expensive Stored PROCEDURE

Plagiarized from here, which was published in 2011.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2018 at 4:33 am

#1976292
RE: View query was fast with literal in WHERE clause, but super-slow using a variable

DesNorton - Wednesday, January 17, 2018 10:46 PM
Mathew McGiffen's blog post Avoid â€œConstantsâ€ in T-SQL shows how the use of a...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 18, 2018 at 4:18 am

#1976291
RE: Creating Temp Table OR Table Variable by executing a stored procedure with parameters

Following on from Thom's post, you can use sp_describe_first_result_set to get the structure for your temp table.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 11, 2018 at 6:11 am

#1975484
RE: CASE statement slows down query drastically

-- Add column Docref to index ix_sent_01
-- in addition to eliminating the key lookup, this will refresh statistics, which...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 11, 2018 at 2:17 am

#1975457
RE: CASE statement slows down query drastically

Jackie Lowery - Wednesday, January 10, 2018 9:11 AM
Is that index dependent on the previous index you gave me? I've been removing...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 10, 2018 at 10:04 am

#1975341
RE: CASE statement slows down query drastically

Jackie Lowery - Wednesday, January 10, 2018 7:41 AM
Took me a sec to figure out how to get that. lol. I'm definitely...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 10, 2018 at 8:15 am

#1975292
RE: CASE statement slows down query drastically

Jackie Lowery - Wednesday, January 10, 2018 7:34 AM
That index gives me a marked improvement. Query time goes from 1:07 to 0:29. ...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 10, 2018 at 7:36 am

#1975281
RE: Need table partitioning implementation guidance for real scenario

ChrisM@Work - Thursday, January 4, 2018 9:23 AM
These are the key references I used recently:
Not necessarily. This new index I've...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 10, 2018 at 6:55 am

#1975264
RE: CASE statement slows down query drastically

Jackie Lowery - Tuesday, January 9, 2018 2:52 PM
I guess i should ask what i can do to be able to add...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 10, 2018 at 1:20 am

#1975228
RE: CASE statement slows down query drastically

Jackie Lowery - Tuesday, January 9, 2018 8:59 AM
Here are the execution plans with and without the case statement. My ultimate goal...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 9, 2018 at 9:11 am

#1975099
RE: CASE statement slows down query drastically

Jackie Lowery - Monday, January 8, 2018 11:09 AM
If i comment out the case statement in this query, it takes less than ...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

January 9, 2018 at 8:11 am

#1975083

Viewing 15 posts - 451 through 465 (of 10,143 total)