ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,711 through 7,725 (of 10,143 total)

RE: Today's Random Word!

Carpenter
^{“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 2, 2010 at 8:57 am

#1188265
RE: Today's Random Word!

Wordstar, Calcstar, Datastar
^{“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 2, 2010 at 7:39 am

#1188210
RE: Today's Random Word!

tosscrosby (7/2/2010)
Chris Morris-439714 (7/2/2010)
19th Century American English. 19th C? Nothing changes then. Anybody want a floating duck house?
Not me, I may have anatidaephobia
Heh...just think "Crispy Duck", you'll be...
^{“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 2, 2010 at 7:17 am

#1188193
RE: Today's Random Word!

Paul White NZ (7/2/2010)
Precision and scale
Measuring worm 😉
^{“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 2, 2010 at 6:47 am

#1188159
RE: Today's Random Word!

tosscrosby (7/2/2010)
sing4you (7/1/2010)
tosscrosby (7/1/2010)
snollygosters
Love the word, but .... what does it mean?
Not a word you'd use in passing conversation but it means "Sleazy politicians or lawyers"
19th...
^{“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 2, 2010 at 6:46 am

#1188158
RE: Are the posted questions getting worse?

jcrawf02 (7/2/2010)
Anybody seen Barry lately? Republication of his '15 ways to lose your cursors' (gonna be singing Simon & Garfunkel in my head all friggin day now) made me wonder?
He...
^{“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 2, 2010 at 6:38 am

#1188143
RE: Check duplicates records while bulk inserting in to Table

Jeff Moden (6/28/2010)
Chris Morris-439714 (6/28/2010)
Everything in your database is valuable, everything outside is garbage. A staging table serves as a firewall between the two.
VERY well stated, Mr Morris! 🙂
Thanks Jeff!...
^{“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 2, 2010 at 3:27 am

#1188084
RE: I really need some recommendations for this query

There are two UNIONed queries here, each containing two correlated subqueries.
Run each UNIONed query separately and note times.
Coment out the correlated subqueries and run and time again. This will give...
^{“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 1, 2010 at 9:35 am

#1187742
RE: Drop Clustred index on primary key

2005_DBA (7/1/2010)
Hi Experts,
How can I drop clustered index on primary key.
what will be the impact. Clustered index is not used. This is index creted on primary key automatically.
Thanks in advance.
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

July 1, 2010 at 7:06 am

#1187642
RE: how to get Getdate() without using convert or cast

parthi-1705 (6/30/2010)
Dan.Humphries (6/30/2010)
K I have to ask why should you not use cast or convert?
Just i am trying to find out any possiable ways are there other than this... you...
^{“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 1, 2010 at 5:08 am

#1187578
RE: HOW to split records of one column into multiple column

Hi
Please review this sample table / data script to ensure that the column names & types are correct and that the data is representative of your problem.
CREATE TABLE #Temp ([DATE]...
^{“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 1, 2010 at 4:09 am

#1187544
RE: Today's Random Word!

John Rowan (6/30/2010)
Motorhead
OOh don't John you'll get PW all dizzy over his umlauts again :hehe:
^{“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

June 30, 2010 at 9:46 am

#1187189
RE: Are the posted questions getting worse?

Grant Fritchey (6/30/2010)
...Maybe a really big article on the best way to nest views inside of views inside of views all while joining views...
A recursive CTE using a recursive CTE...
^{“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

June 30, 2010 at 8:07 am

#1187091
RE: How to sum rows

What is the result set used for, Steven?
^{“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

June 30, 2010 at 5:05 am

#1186967
RE: Can we have more than one identity columns in a table

diva.mayas (6/29/2010)
Hi
Can we have more than one identity columns in a table.
if yes then why, if no then why
i am interested to know the reasons behind 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

June 30, 2010 at 2:51 am

#1186925

Viewing 15 posts - 7,711 through 7,725 (of 10,143 total)