ChrisM@Work

Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 10,143 total)

RE: Speeding Up Delete's on Large Databases

Jeff, the method Eirikur's describing works really well. We implemented such a method here for cleaning up a substantial table earlier in the year. The existing method was causing some...
^{“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

November 1, 2016 at 4:54 am

#1909822
RE: Are the posted questions getting worse?

Luis Cazares (10/31/2016)
Sean Lange (10/31/2016)
jasona.work (10/31/2016)
Ed Wagner (10/31/2016)
Sean Lange (10/31/2016)
jasona.work (10/31/2016)
ChrisM@Work (10/31/2016)
Sean Lange (10/31/2016)
ChrisM@Work (10/31/2016)
Sean Lange (10/31/2016)
Ed Wagner (10/31/2016)
ThomasRushton (10/31/2016)
Wryan138 (10/30/2016)
So in lieu of some marvelous SQL wizardry, I'm just...
^{“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

November 1, 2016 at 2:53 am

#1909798
RE: Are the posted questions getting worse?

Sean Lange (10/31/2016)
ChrisM@Work (10/31/2016)
Sean Lange (10/31/2016)
Ed Wagner (10/31/2016)
ThomasRushton (10/31/2016)
Wryan138 (10/30/2016)
So in lieu of some marvelous SQL wizardry, I'm just trying to help out a little.
Wayne
Welcome aboard. I must admit,...
^{“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

October 31, 2016 at 7:35 am

#1909615
RE: Are the posted questions getting worse?

Sean Lange (10/31/2016)
Ed Wagner (10/31/2016)
ThomasRushton (10/31/2016)
Wryan138 (10/30/2016)
So in lieu of some marvelous SQL wizardry, I'm just trying to help out a little.
Wayne
Welcome aboard. I must admit, I do use...
^{“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

October 31, 2016 at 7:24 am

#1909607
RE: Performance improvement on statement.

ben.brugman (10/24/2016)
ChrisM@Work (10/21/2016)
The guesses made by the optimiser are whacked somewhat by the ranges.
Yes they are WHacked.
Try forcing a loop join reading first from the ranges table like this:
SELECT...
^{“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

October 31, 2016 at 2:57 am

#1909555
RE: sCHOOL.BAK

muhamadehsan (10/24/2016)
I have a school.bak file I want to convert this to school.mdb file can any one convert for me , I am asking because I failed to install sql...
^{“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

October 24, 2016 at 5:50 am

#1908328
RE: Performance improvement on statement.

drew.allen (10/21/2016)
The problem with ranges is that it requires two range predicates (>=, >, <=, or <), but SQL indexes only efficiently handle one range predicate. There is 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

October 21, 2016 at 9:54 am

#1908013
RE: Performance improvement on statement.

The guesses made by the optimiser are whacked somewhat by the ranges. Try forcing a loop join reading first from the ranges table like this:
SELECT *
FROM #Ranges r
INNER...
^{“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

October 21, 2016 at 7:53 am

#1907963
RE: Triggers inside Stored procedure

RAKSHITHA (10/21/2016)
I have a proc whose structure is as below:
Create Proc
As
Begin
Insert Statement................... ( which calls insert trigger)
...
...( rest of...
^{“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

October 21, 2016 at 4:17 am

#1907894
RE: SQL query running slow after upgrading from 2005 to SQL 2012

wtren (10/21/2016)
did you try the maxdop option?
Pointless - it's a serial plan.
^{“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

October 21, 2016 at 4:15 am

#1907892
RE: SQL query running slow after upgrading from 2005 to SQL 2012

Sqlsavy (10/20/2016)
Thank you everyone.
I can't post the actual query plan because of company policy.
You've been very helpful we've logged a case with MS now
SQL Sentry Plan Explorer has an option...
^{“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

October 20, 2016 at 3:08 am

#1907582
RE: Dynamic rows into columns

seismicbeat (10/19/2016)
Hello,
Sorry for bothering you again. I have a couple of questions about putting the dynamic pivot results to a local table or view. I think, I can use INTO...
^{“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

October 20, 2016 at 2:00 am

#1907575
RE: SQL query running slow after upgrading from 2005 to SQL 2012

John Mitchell-245523 (10/19/2016)
My question is this: if you have 90GB of memory and more on your server, why not let SQL Server use it? But I agree, let's see...
^{“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

October 19, 2016 at 8:29 am

#1907429
RE: SQL query running slow after upgrading from 2005 to SQL 2012

Sqlsavy (10/19/2016)
I’m seeing some strange behaviour with the ''update" query
If you increase the ‘available’ memory available to the SQL Instance to >90gb then the query seems to build an...
^{“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

October 19, 2016 at 8:09 am

#1907424
RE: Are the posted questions getting worse?

ThomasRushton (10/19/2016)
Brandie Tarvin (10/19/2016)
ThomasRushton (10/19/2016)
rodjkidd (10/19/2016)
ThomasRushton (10/19/2016)
In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."
at which point I lost the plot.
are you sure...
^{“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

October 19, 2016 at 6:13 am

#1907388

Viewing 15 posts - 1,111 through 1,125 (of 10,143 total)