ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,916 through 9,930 (of 10,143 total)

RE: I got burned today at a SQL Server Interview!

More amusing anecdotes in a similar vein:
http://www.ussdevilfish.com/images/gall29.htm
^{“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 14, 2008 at 6:37 am

#789573
RE: I got burned today at a SQL Server Interview!

Grant Fritchey (3/14/2008)
I don't know if I'd call poking holes in water the "front lines" but from what I saw of the AF, you guys had it pretty sweet.
And 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

March 14, 2008 at 6:18 am

#789562
RE: UPDATING using a WHILE LOOP?

Hi Debbie
If you haven't already seen today's article by Jeff Moden about tuning UPDATES, then it's worth a read. There's a 'gotcha' in the code I posted earlier, which should...
^{“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 14, 2008 at 5:07 am

#789537
RE: I got burned today at a SQL Server Interview!

Matt Miller (3/13/2008)
Grant Fritchey (3/13/2008)
I got hired once because I'd been in the Navy... that's as close as I've got to an "outside" talent getting me hired story... Jeez, 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

March 13, 2008 at 3:07 pm

#789333
RE: I got burned today at a SQL Server Interview!

Scary stuff. With such an exemplary health and safety record, what do you make of this...
http://technology.newscientist.com/article/dn13459-disposable-nuclear-reactors-raise-security-fears.html
A friend who left school in 1975 ("Confessions of an Old Git") to work at...
^{“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 13, 2008 at 1:55 pm

#789310
RE: I got burned today at a SQL Server Interview!

Yeah come on Steve, let's hear your best story about farting horses! 😛
^{“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 13, 2008 at 8:13 am

#789080
RE: I got burned today at a SQL Server Interview!

I'm not worthy!
Don't fink so mate, you made yours and you've a right to be proud of that! It's a different sport to recurve/wheelybow, more fun, less OCD 😎
Heh yeah...
^{“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 12, 2008 at 10:11 am

#788675
RE: I got burned today at a SQL Server Interview!

Grant Fritchey (3/12/2008)
Nice. I made my long bow in a course with the Royal Bowyer of England. It's only about 50-60lb pull, but it'll throw a bodkin point about 75...
^{“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 12, 2008 at 9:37 am

#788659
RE: I got burned today at a SQL Server Interview!

This thread has ample nerdiness for those amused by 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

March 12, 2008 at 9:10 am

#788635
RE: I got burned today at a SQL Server Interview!

How close could you get with your axe before one of my nice homemade 32" POC arras pierces your steel breastplate? Of course, any arras left over make good spits...
^{“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 12, 2008 at 8:40 am

#788599
RE: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

I'm sure you've checked this out, John, but BOL says of connection-level settings...
"SQL Server evaluates datetime constants at run time. A date string that works for the date formats expected...
^{“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 12, 2008 at 8:35 am

#788593
RE: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

John
The implicit conversion of update_timestamp to small datetime is causing the problem. Use explicit conversion...
WHERE sta_code = 'V'
AND CONVERT(smalldatetime, update_timestamp, style) >= @extract_start_date
...replace style with 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

March 12, 2008 at 6:57 am

#788501
RE: Updating Excel - Syntax error in UPDATE Statement

You can't delete a row, but since you can blank out cells, for most purposes is doesn't matter.
^{“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 11, 2008 at 7:34 am

#787957
RE: Updating Excel - Syntax error in UPDATE Statement

Jim Russell (3/11/2008)
Thanks!
At first glance it looks right on. (I'll have to study it a bit, since I'm a slow learner.)
That should be a big help!
heh heh I'm sure 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

March 11, 2008 at 7:01 am

#787928
RE: Updating Excel - Syntax error in UPDATE Statement

You're welcome, Jim. Interesting that it worked for a named range but not for a worksheet (tab). I've only used this with worksheets.
Here's a sproc which you can tailor...
^{“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 11, 2008 at 5:43 am

#787874

Viewing 15 posts - 9,916 through 9,930 (of 10,143 total)