ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,816 through 4,830 (of 10,143 total)

RE: Slows system performance

If the log file has insufficient free space to handle the logging data from a batch of deletes, then yes the file will grow. Are you manually changing the size...
^{“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

April 15, 2013 at 4:08 am

#1606406
RE: userdefined function for average

afuchs 47083 (4/4/2013)
Hi guys,
I tried to create a new userdefined function for calculating the average of top 10 values on different columns of my table:
Example:
SELECT AVG(a02) FROM (SELECT TOP...
^{“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

April 15, 2013 at 3:53 am

#1606401
RE: Slows system performance

Krishna1 (4/15/2013)
the script given gives me the size of the log file and used space. I would line to know why delete operation should increase the log file?
Deletes are fully...
^{“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

April 15, 2013 at 3:44 am

#1606400
RE: Slows system performance

Krishna1 (4/15/2013)
After addind checkpoint also its increading the log file size
Even with batching, simple recovery mode and checkpointing, there will be a minimum log space requirement for each batch. If...
^{“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

April 15, 2013 at 3:34 am

#1606395
RE: Multiple DMLS in one when clause of MERGE Statement

MERGE Vacancy.TB_FTSearchData as t -- target
USING vacancy.TB_Vacancy as s -- source
ON t.FTSearchVacancyInternalID = s.VacancyInternalID
AND t.FTSearchContractID = s.VacancyContractID
WHEN not Matched by source THEN DELETE
WHEN not Matched by target...
^{“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

April 15, 2013 at 2:15 am

#1606373
RE: Multiple DMLS in one when clause of MERGE Statement

28.kanikasoni (4/12/2013)
Hi All,
I want to use 2 DMLS in When not Matched by target clause ie. first insert and then update.But I am getting problem while executing this code .Please...
^{“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

April 15, 2013 at 1:49 am

#1606368
RE: Dynamic Date Columns

Pivot or crosstab. Can you provide a few more details? There's a link in my sig providing posting guidelines.
^{“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

April 15, 2013 at 1:43 am

#1606367
RE: Begginer Sub Query problem

Something like this?
;WITH Resolver AS (
SELECT [Level] = 1, CompanyID, CompanyName, Heirarchy, ParentCompanyID,
Hpath = CAST(CompanyID AS VARCHAR(50)),
ParentCompanyNames = CAST(NULL AS VARCHAR(100))
FROM Company
WHERE ParentCompanyID = 0
UNION ALL
SELECT [Level] = r.[Level]+1,...
^{“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

April 15, 2013 at 1:32 am

#1606364
RE: Stuck on querying 3 tables where I'm looking for non-matches

Melanie Peterson (4/12/2013)
LitHold and LitHoldDetails are connected via the LitHoldID column, and LitHoldDetails and EmailTemplate are connected via the LitHoldDetailsID column. Apart from that and the table structures, what else...
^{“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

April 12, 2013 at 8:32 am

#1605999
RE: If statement in combination with case statement

Problem is Voice has 20 case statements,
Can you post up three or four of them please?
^{“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

April 12, 2013 at 8:26 am

#1605993
RE: Obtaining earliest change for one colum?

Rob-350472 (4/12/2013)
I'd like to have time to try the above non CTE approach, time doesn't allow at the moment but hopefully at some point.
FYI the #test replica on my 'real'...
^{“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

April 12, 2013 at 8:11 am

#1605986
RE: Obtaining earliest change for one colum?

Lynn Pettis (4/12/2013)
The CTE and NoCTE versions are comparable on a small data set. I'd like to try them both on a million row data set and see how...
^{“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

April 12, 2013 at 8:02 am

#1605981
RE: Slows system performance

DevDB (4/12/2013)
Use Batch insert/update/ delete instead of doing it in one big batch.
The OP is batching.
^{“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

April 12, 2013 at 8:01 am

#1605979
RE: Stuck on querying 3 tables where I'm looking for non-matches

Shouldn't templateID be a column in LitHoldDetails? I think you've got the relationship the wrong way round.
^{“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

April 12, 2013 at 7:57 am

#1605975
RE: can I use while loop for only one column?

abhas (4/12/2013)
Hi All,
Please help me on below scenario.
I am having application where user selects startdate and enddate from his application(front end). but if he selects Startdate is 2013/01/01 and EndDate...
^{“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

April 12, 2013 at 7:52 am

#1605969

Viewing 15 posts - 4,816 through 4,830 (of 10,143 total)