ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,411 through 7,425 (of 10,143 total)

RE: Are the posted questions getting worse?

Brandie Tarvin (9/10/2010)
Chris Morris-439714 (9/10/2010)
Brandie, what's @=Pbbt?
It's like a raspberry, sticking one's tongue out, making the phbbt noise, and probably drenching everyone in the vicinity in the process.
You're the...
^{“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

September 10, 2010 at 8:27 am

#1219210
RE: T-SQL code performance - am I missing something obvious

Balance (9/10/2010)
Thanks chap - code probably too embarassing to post!;-)
If you think there's room for improvement, then post it - don't be shy, we're all learners here.
Anyway, the coffee lands...
^{“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

September 10, 2010 at 8:24 am

#1219206
RE: Are the posted questions getting worse?

Brandie, what's @=Pbbt?
It looks like Cyclops eating a bacon butty badly.
^{“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

September 10, 2010 at 8:16 am

#1219192
RE: T-SQL code performance - am I missing something obvious

Jeff's excellent article will explain string splitting - if you're unsure of anything, just ask.
This
(SELECT TOP 200 [n] = ROW_NUMBER() OVER(ORDER BY [name]) FROM master.dbo.syscolumns) n is a mini...
^{“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

September 10, 2010 at 8:11 am

#1219186
RE: Today's Random Word!

dbowlin (9/10/2010)
Stuart Davies (9/9/2010)
peripatetic
I walk every day, but usually in circles.
Similar to a groundsman then - who walks every day, frequently in circles 😛
^{“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

September 10, 2010 at 7:26 am

#1219143
RE: how to return records in squence of inner join table?

There is no guarantee that rows will be returned in any particular unless ORDER BY is specified.
There is also no guarantee that rows will be inserted in a particular order,...
^{“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

September 10, 2010 at 6:16 am

#1219115
RE: Calling a UDF

vani_r14 (9/8/2010)
[font="Tahoma"]
I have a function called Split and i would like to know - If can call that function in the where clause of Select Statement. This is a 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

September 10, 2010 at 5:37 am

#1219096
RE: Circular reference

the_rutter (9/10/2010)
I'm actually a .NET developer with little SQL experience. I noticed this circular reference in a new project I am working on and it raised alarms in my head....
^{“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

September 10, 2010 at 5:02 am

#1219077
RE: why is one query better performing than the other

Look at it again. A cross join doesn't have to generate millions and millions of rows, and since you've got a filter on the derived table, this one won't, it...
^{“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

September 10, 2010 at 4:31 am

#1219065
RE: why is one query better performing than the other

The question is moot really. Since neither the derived table mostRecentStatus
nor the table orderlinestatus are joined to orders or orderlines, you have a cross join.
Try this instead:
SELECT
o.[Order],
ol.product,...
^{“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

September 10, 2010 at 3:49 am

#1219052
RE: select multirecs from single recs without cursor

This couldn't have come at a better time, Wayne & I had something similar this week. Can you post the ddl for the table, along with a few INSERTs 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

September 10, 2010 at 2:59 am

#1219045
RE: Unexpected Columns being set to NULL with record updates

Please post the ddl for the table, and the complete update statement which you are currently using.
^{“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

September 10, 2010 at 2:34 am

#1219032
RE: saving a date to a varchar field as YYYY-MM-DD

Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
dave-dj (9/9/2010)
wow. Thanks for all the quick responses!. That's perfect thank you.
As always the ladies and gents of sqlserver central have been a great help.!
Everyday...
^{“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

September 10, 2010 at 2:17 am

#1219022
RE: saving a date to a varchar field as YYYY-MM-DD

-- the stored procedure returns a DATETIME data type:
DECLARE @MyDate nvarchar(255)
SET @MyDate = GETDATE()
SELECT @MyDate
-- 'Sep 9 2010 4:46PM'
-- You need to CONVERT the output to a character...
^{“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

September 9, 2010 at 9:51 am

#1218742
RE: SubSelect Statement not returning accurate results

No worries.
Consider making your WHERE clauses SARGable:
DECLARE @Startmonth DATE, @Endmonth DATE, @Startday DATE, @Endday DATE
SET @Startmonth = DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0)
SET @Endmonth = DATEADD(MONTH,1,@Startmonth)
SET @Startday = DATEADD(day,DATEDIFF(day,0,GETDATE()),0)
SET @Endday = DATEADD(day,1,@Startday)
SELECT @Startmonth, @Endmonth, @Startday,...
^{“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

September 9, 2010 at 9:24 am

#1218716

Viewing 15 posts - 7,411 through 7,425 (of 10,143 total)