ChrisM@Work

Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 10,143 total)

RE: T-SQL Variable vs String Equivalent

If you examine the two plans in the first post of this thread, the first one – for the query with a constant predicate – has been considered for simple...
^{“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 10, 2013 at 3:36 am

#1605142
RE: Slows system performance

Krishna1 (4/10/2013)
thanks. I will check the perfromace and the size of log after adding the checkpoint
How do u write it,
Begin tran
Commit tran
checkpoint
if i have 2 begin tran / commot tran...
^{“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 10, 2013 at 3:12 am

#1605135
RE: Query - Nested Loop Join

sqldba_newbie (4/9/2013)
In below query , in the exec plan i see nested loop join on TBFE table. This is executed for 25,000 times. I could force a hash join there...
^{“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 10, 2013 at 3:06 am

#1605133
RE: Please tell me how can I write one query to resolve this problem.

Hi Liam, welcome aboard. Before you start, have a read of this article[/url]. It describes how to post a question and what to include with it, to increase your chances...
^{“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 10, 2013 at 1:50 am

#1605118
RE: Inserting into an auto increment PK field

Have a look at IDENTITY_INSERT in Books Online.
^{“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 10, 2013 at 1:44 am

#1605117
RE: Which of the two queries is better ???

T.Ashish (4/4/2013)
Hi All,
I have attached two queries with table definition and sample data.
Query 2 is working better then query 1.
Now the actual question is:
Should I...
^{“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 10, 2013 at 1:40 am

#1605116
RE: Slows system performance

Two key points - don't shrink after load, it will only cost you next time around; and checkpoint after each COMMIT to clear completed transactions from the log.
Grant Fritchey has...
^{“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 10, 2013 at 1:29 am

#1605114
RE: split single row into four rows.

abhas (4/9/2013)
Thank you Chris.
I found below code some where else which is resemble to my requirement. Now i want to insert whole result set into my database table. 🙂
DECLARE...
^{“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 10, 2013 at 1:11 am

#1605109
RE: SQL /Procedure - for Transpose and Calculation

sudhirnune (4/9/2013)
Thanks all for helping on this: below is procedure which does the Trick
Create procedure USP_TEST
@NAME NVARCHAR(20)
AS
BEGIN
IF object_id(N'tempdb..##TEMP_TEST') is not null
DROP table ##TEMP_TEST;
DECLARE @cols AS NVARCHAR(MAX),
...
^{“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 10, 2013 at 1:09 am

#1605108
RE: Slows system performance

Which recovery model is your db set to?
^{“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 10, 2013 at 12:59 am

#1605106
RE: split single row into four rows.

This might help:
IF object_id('TempDB..#Temp') IS NOT NULL
DROP TABLE #Temp
CREATE TABLE #Temp (DateTimeRow DATETIME)
DECLARE @STARTDATE DATETIME, @StartTimeChar CHAR(5), @EndTimeChar CHAR(5);
SELECT
@STARTDATE = CAST(GETDATE() AS DATE),
@StartTimeChar = '08:00', -- note left-padded digit...
^{“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 9, 2013 at 9:05 am

#1604881
RE: SQL /Procedure - for Transpose and Calculation

sudhirnune (4/9/2013)
I will try to Explain you the Scenario and need Suggestion:
1. I have te table which is Similar to TEST_SRC for which will tipically has 4000 to 5000 Payment...
^{“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 9, 2013 at 9:04 am

#1604880
RE: split single row into four rows.

abhas (4/9/2013)
Hi,
Still facing an issue while inserting records. I have created Tally table with N. If i use select by applying join then data is showing properly but while inserting...
^{“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 9, 2013 at 8:08 am

#1604832
RE: SQL /Procedure - for Transpose and Calculation

sudhirnune (4/9/2013)
yes and might increase at any point of time.
So to summarise, you want to take three or four very simple queries and convert them into a series of statements...
^{“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 9, 2013 at 7:50 am

#1604817
RE: SQL /Procedure - for Transpose and Calculation

sudhirnune (4/9/2013)
Because formula are different for Different Scenario
I need to make it dinamic so that based on the Scenario Formula should be Take and Calculated.
SCENARIO - TGT_PAYMENT_TYPE - PAYMENT_FORMULA
NORMAL ...
^{“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 9, 2013 at 7:21 am

#1604796

Viewing 15 posts - 4,861 through 4,875 (of 10,143 total)