ChrisM@Work

Forum Replies Created

Viewing 15 posts - 6,316 through 6,330 (of 10,143 total)

RE: Issue: Index creation is not running in parallel

BOL also states "To suppress parallel plan generation, set max degree of parallelism to 1". My italics. If parallel plan generation is suppressed, should it matter what MAXDOP setting you'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

May 16, 2012 at 7:28 am

#1488390
RE: Issue: Index creation is not running in parallel

Because "The instance is configured with max degree of parallelism=1", perhaps?
^{“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

May 16, 2012 at 6:45 am

#1488337
RE: Capture data rows from output cursor into table variable

kingdonshel (5/13/2012)
I have been trying to insert rows into table variable from the reults of an output cursor ...
What is it that you're trying to accomplish here? If you can...
^{“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

May 15, 2012 at 1:49 am

#1487556
RE: Are the posted questions getting worse?

GilaMonster (5/12/2012)
Talking about London, heading that way tonight and won't have much time for SSC while I'm there. Could some people keep a watch for corrupt databases, production restores or...
^{“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

May 14, 2012 at 7:03 am

#1487075
RE: Where Statement affects Index?

Charmer (5/11/2012)
Thank you Guys...i am clear now..
You will be if you can find the time to read this excellent article by David Durant[/url].
^{“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

May 11, 2012 at 7:15 am

#1486296
RE: Where Statement affects Index?

Charmer (5/11/2012)
ChrisM@Work (5/11/2012)
Charmer (5/11/2012)
Hi Friends,
I am here to discuss the general topics of index....
One of my colleague says if we add filtering(where statement) , it will affect index. Is that...
^{“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

May 11, 2012 at 7:13 am

#1486292
RE: Where Statement affects Index?

Charmer (5/11/2012)
Hi Friends,
I am here to discuss the general topics of index....
One of my colleague says if we add filtering(where statement) , it will affect index. Is that true.? 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

May 11, 2012 at 6:51 am

#1486273
RE: DateAdd together with DateDiff

It's been longer than a coffee break since the OP last posted anything 😀
^{“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

May 11, 2012 at 1:20 am

#1486123
RE: improve performance of sp

Tim Walker. (5/10/2012)
I have amended my original proposal to a genuinely useful one:
CREATE PROC WhenCanIGoHome AS
SELECT 'You can go home at '+CONVERT(varchar, DATEADD(s,5+(3595*RAND(CHECKSUM(NEWID()))),GETDATE()),108)
:hehe:
Tim
Late again! Your dinner's in the dog.
^{“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

May 10, 2012 at 6:50 am

#1485663
RE: case statement

ranuganti (5/10/2012)
so how should we use this statement without returning 2 records
select
case when Void = 0 then SUM(weight) end AS totalweight
from test
when i use this i get
result as:
total...
^{“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

May 10, 2012 at 6:34 am

#1485648
RE: Need help with SQL statement using COUNT function

mldardy (5/8/2012)
I am using a Select statement where I get the difference between two columns (ForecastQtyContainers and LastYearQtyActualContainers). I'm able to get that fine but I want take the Difference...
^{“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

May 10, 2012 at 6:03 am

#1485628
RE: String conversion

anthony.green (5/10/2012)
if its a date time column could you not just do
select CONVERT(varchar,getdate(),10)
No leading zero for days and months...
^{“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

May 10, 2012 at 2:20 am

#1485535
RE: String conversion

SELECT STUFF(REPLACE('/'+CONVERT(VARCHAR(10),GETDATE(),1),'/0','/'),1,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

May 10, 2012 at 1:47 am

#1485517
RE: String conversion

Jeff Moden (5/9/2012)
BWAAA-HAAA!!! This will do it! :-P:-D Makes a "great" interview question. :sick:
WITH F(x) AS (SELECT TOP (CHECKSUM(66-ASCII('A'))) '/'+CONVERT(CHAR(8),GETDATE(),CAST(EXP(0) AS INT)) FROM sys.objects)
SELECT STUFF(REPLACE(LEFT(x,POWER(73,1/2)*POWER(25,1/2.0)),'/0','/')
...
^{“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

May 10, 2012 at 1:42 am

#1485513
RE: improve performance of sp

riya_dave (5/9/2012)
i remove cursor with while ,not improving still.
what other i need to use in place of cursor
TSQL 101, SQL for Dummies, or any other TSQL book for beginners. Spend...
^{“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

May 10, 2012 at 1:25 am

#1485506

Viewing 15 posts - 6,316 through 6,330 (of 10,143 total)