ChrisM@Work

Forum Replies Created

Viewing 15 posts - 5,986 through 6,000 (of 10,143 total)

RE: Are the posted questions getting worse?

GilaMonster (7/30/2012)
ChrisM@Work (7/30/2012)
Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady, Gail. ...
^{“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

July 30, 2012 at 5:05 am

#1519089
RE: Are the posted questions getting worse?

Someone's just posted a reply to a request from Gail and my best guess is that she's fallen of her chair laughing. You're a bad lady, Gail. 😎
^{“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

July 30, 2012 at 4:49 am

#1519081
RE: Order without Order by

danielfountain (7/30/2012)
Phil Parkin (7/30/2012)
Doesn't the execution plan give you any clues as to which index it is using?
Thats what i was hoping - but still cant see it. Dont...
^{“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

July 30, 2012 at 4:33 am

#1519078
RE: any order max, min in simple way

aspanwar27 (7/23/2012)
Comments posted to this topic are about the item <A HREF="/scripts/92227/">any order max, min in simple way</A>
Its not clear what you're trying to do. We use these queries 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

July 30, 2012 at 4:30 am

#1519077
RE: Order without Order by

danielfountain (7/30/2012)
Thanks for the explainations.
Unfortunately i do have to worry about it. Obviously the execution plan hasnt changed in a while as people have got used to the 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

July 30, 2012 at 4:08 am

#1519062
RE: Join operation over String non-index fields

You're welcome Paul.
paul.pauldj54 (7/30/2012)
...the business keys always hold numeric values and they are defined as Strings...
A column containing values with leading zero's can only be a string.
...For a fact 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

July 30, 2012 at 4:04 am

#1519060
RE: NonClustered index on Clustered table

Brandie Tarvin (7/27/2012)
SQL Server has pointers that tell it which indexes refer to which records. Your James names with different IDs won't get lost. However, if you don't have your...
^{“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

July 30, 2012 at 3:29 am

#1519049
RE: Case Statement Problem

schauhan13 (7/29/2012)
Sorry if I was unclear , when I try to run this stored procedure, it gives me error that 'Incorrect syntax near Case'
Code is much easier to debug outside...
^{“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

July 30, 2012 at 3:21 am

#1519042
RE: Order without Order by

Hi Daniel
Without an ORDER BY, SQL Server will return the results in whatever order they fall out of the execution plan. If the plan changes - and there are many...
^{“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

July 30, 2012 at 3:14 am

#1519039
RE: CTE in Infinite Loop

santlou (7/30/2012)
I have a CTE that is in a loop. I need to limit the recursive query so that data that has already been selected is not selected again.
...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

July 30, 2012 at 3:05 am

#1519035
RE: Join operation over String non-index fields

Hi Paul
Apart from the fact that a simple join between the two tables on konsumfeld
SELECT ...
FROM Tableb b
LEFT JOIN Tablea a ON a.konsumfeld = b.konsumfeld
would eliminate rows from tableb...
^{“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

July 30, 2012 at 2:44 am

#1519029
RE: Recursive Golf to-par calculation

pixelwiz (7/27/2012)
Hi Sean, you're right. I know. It's just been driving me nuts for 2 days and I can't even figure out how to explain it right. ...
^{“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

July 27, 2012 at 9:39 am

#1518598
RE: Recursive Golf to-par calculation

Sean's nailed it. You've got data that you can see and which you have already queried in an attempt to get the results - we can't see it, we 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

July 27, 2012 at 9:25 am

#1518586
RE: Are the posted questions getting worse?

Gianluca Sartori (7/27/2012)
Jeff Moden (7/27/2012)
SQL Kiwi (7/27/2012)
Jeff Moden (7/27/2012)
I had an ephipany that just hit me like a ton of bricks....
I see! Well that explains it
...
Man! 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

July 27, 2012 at 9:19 am

#1518583
RE: next day function

harri.reddy (7/27/2012)
hi
i want next day function
for example. if i enter 12/31/2008 ,it should give me 01/01/2009
Check out DATEADD() in BOL.
^{“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

July 27, 2012 at 9:00 am

#1518572

Viewing 15 posts - 5,986 through 6,000 (of 10,143 total)