ChrisM@Work

Forum Replies Created

Viewing 15 posts - 8,041 through 8,055 (of 10,143 total)

RE: Today's Random Word!

Tom.Thomson (4/7/2010)
Chris Morris-439714 (4/7/2010)
Quiver
(Janey from accounts just swished past)
Oh dear, your sig is a little suggestive after that message. I hope she doesn't get to see it:-D.
You think that's...
^{“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 7, 2010 at 2:41 am

#1147133
RE: Today's Random Word!

Quiver
(Janey from accounts just swished past)
^{“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 7, 2010 at 2:18 am

#1147117
RE: Today's Random Word!

Beth
^{“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 6, 2010 at 8:20 am

#1146515
RE: Today's Random Word!

Lace
^{“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 6, 2010 at 7:03 am

#1146452
RE: Today's Random Word!

Paul White NZ (4/6/2010)
Chris Morris-439714 (4/6/2010)
Berm
...baby berm
Peach
^{“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 6, 2010 at 6:54 am

#1146445
RE: Today's Random Word!

Berm
^{“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 6, 2010 at 6:27 am

#1146427
RE: The Missing Certification

Jeff Moden (4/2/2010)
... does anyone know if MCM's are taught how to use something like a Tally table or how to do a dynamic cross tab in their 3 weeks...
^{“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 6, 2010 at 2:34 am

#1146354
RE: Are the posted questions getting worse?

Usually F.
SET LANGUAGE TO hamster for E.
^{“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 1, 2010 at 9:45 am

#1144146
RE: The Missing Certification

Paul White NZ (4/1/2010)
Chris Morris-439714 (4/1/2010)
I love these answers. Who needs a thumping great book?
You do, dear :laugh:
(private joke)
Oh doen't!
^{“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 1, 2010 at 8:09 am

#1144006
RE: The Missing Certification

Paul White NZ (4/1/2010)
GSquared (4/1/2010)
Could also happen if the table is in a read-only file or datbase, which has the same effect as read uncommitted but without the risks associated...
^{“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 1, 2010 at 7:59 am

#1143990
RE: Today's Random Word!

Chubbychaser
^{“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 1, 2010 at 7:58 am

#1143986
RE: Are the posted questions getting worse?

Dave Ballantyne (4/1/2010)
Have i just fallen hook line and sinker for some weird april fool's 😉
http://www.sqlservercentral.com/Forums/Topic894474-338-1.aspx
Nope - just drop the month name from the sentence.
^{“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 1, 2010 at 2:56 am

#1143757
RE: The Missing Certification

CirquedeSQLeil (3/31/2010)
Jeff Moden (3/31/2010)
Grant Fritchey (3/31/2010)
dma-669038 (3/31/2010)
Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between...
^{“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 1, 2010 at 2:44 am

#1143751
RE: Today's Random Word!

Lose weight? Pah! Try putting weight on, you slackers!
^{“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 1, 2010 at 2:37 am

#1143747
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/31/2010)
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/31/2010)
HR read your posts???
SSC HR...
Oh. They monitor these threads?
You work for SSC (redgate)?
It was probably a report, Jasey-wasey. I work for a posh...
^{“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

March 31, 2010 at 9:31 am

#1143194

Viewing 15 posts - 8,041 through 8,055 (of 10,143 total)