Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,286 through 39,300 (of 59,098 total)

RE: Stop, Don't Panic

Steve Jones - Editor (3/17/2010)
I don't know that I'd wash my hands of something that was ongoing. I've seen sysadmins try to do something because I was slower to respond,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 17, 2010 at 8:32 am

#1135277
RE: Computed Column Help Please

GSquared (3/17/2010)
Jeff Moden (3/16/2010)
...I have to also strongly agree with something else you said...
GSquared
"if it's clever enough to be complicated, you're doing it wrong"
One of my favorite rules. Knowledge...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 17, 2010 at 8:26 am

#1135267
RE: Stop, Don't Panic

GSquared (3/17/2010)
Jeff Moden (3/17/2010)
What about you come in and someone else has already started a restore of the production database from midnight?
It's real simple then... They didn't call me to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 17, 2010 at 8:19 am

#1135259
RE: TempDB doing my nut in

I'm just curious. You say it grows out of control but didn't say how big TempDB was getting. How big is it getting?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 17, 2010 at 8:03 am

#1135242
RE: Stop, Don't Panic

What about you come in and someone else has already started a restore of the production database from midnight?
It's real simple then... They didn't call me to ask my advice...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 17, 2010 at 12:15 am

#1135013
RE: remove leading Zeros while importing any column from text file to SQL database

WayneS (3/16/2010)
Have you tried transforming it to an int, and then back to a string? That seems like it should do what you're trying to accomplish.
Ummm... why would you convert...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 17, 2010 at 12:06 am

#1135011
RE: Are the posted questions getting worse?

Now that you mention it, I remember that post. That was before I turned on the SWAG light, though. :hehe:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 11:33 pm

#1135000
RE: Are the posted questions getting worse?

Most of the ODBC Scalar functions have direct equivalents in T-SQL. But... this one is very interesting...
SELECT d = {fn CURRENT_DATE()}
I've gotta see if I can find more goodies...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 11:06 pm

#1134993
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
Jeff Moden (3/16/2010)
Was a real SWAG on my part, too! 🙂
Scientific wild-*** guess?
Special Warfare Action Group?
Silly wild-*** guess?
Stuff we all get?
Smart wild-*** guess?
Software wild-*** guesstimate?
Sold without a guarantee?
Nah......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 11:03 pm

#1134992
RE: Are the posted questions getting worse?

I was just getting ready to post that I sussed it...
ODBC timestamp data in Books Online. Was a real SWAG on my part, too! 🙂
Thanks for the link, Paul......
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 10:47 pm

#1134986
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
Jeff Moden (3/16/2010)
I assume that by "explicit date" you mean something like '1900-01-01'... and that's not a date either... that's a string that looks like a date. 😛
Aside...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 10:39 pm

#1134982
RE: Calculating total working hours exclude launch, smoking...and etc times

Dehqon D. (3/16/2010)
Hi Forum,
I'm so sorry that I posted the same massage again and again. I'm totally new, and I didn't realize that my posts are getting to the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 10:22 pm

#1134979
RE: Are the posted questions getting worse?

29 is also my record for the number of pork chops I've had in the air at the same time. I was pretty ticked that day... 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 10:04 pm

#1134976
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
GilaMonster (3/16/2010)
137 - The inverse of the 'fine structure constant'.
...and the 33^rd prime number. Retaining the theme of a, you should probably also use 29 (the 10^th...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 10:03 pm

#1134975
RE: T-SQL: Why “It Depends”

ith the last couple of posts in mind, I hope everyone realizes that the big brother to "It Depends" is "Test it!". 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 16, 2010 at 10:00 pm

#1134972

Viewing 15 posts - 39,286 through 39,300 (of 59,098 total)