Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,256 through 39,270 (of 59,072 total)

RE: Looks like a PIVOT table problem, but for text, not aggregate data

Rhett Lowson (3/16/2010)
but I can't 'aggregate' my text
Sure you can... MAX...
--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 9:29 am

#1135353
RE: loops,ROW_NUMBER,cursor

Peleg... for better answers quicker, please see the first link in my signature line below.
I see what you're trying to do... it's called "Concatenation". There's also several other ways...
--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 9:27 am

#1135349
RE: Transposing repeating sets of rows into colums

The problem is that there's nothing in the bulk table to guarantee the order and I don't trust an unindexed heap to do so.
--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 9:23 am

#1135344
RE: jobs are runinng long time (urgent )

ramyours2003 (3/17/2010)
iam facing problem in my production system that the jobs are taking longtime from past days to complete , even backup jobs are taking long...
--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 9:15 am

#1135334
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

Viewing 15 posts - 39,256 through 39,270 (of 59,072 total)