Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,291 through 31,305 (of 59,101 total)

RE: Need Query Help Urgent

prashantgoswami2007 (2/2/2012)
I think there is no need to explain this.
Actually, you might want to explain why you wrote code that takes 10 times longer to run, returns duplicate answers, can't...
--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)

February 2, 2012 at 7:51 am

#1441847
RE: Trimming data from cells.

Eric M Russell (2/1/2012)
tyson.price (2/1/2012)
Eric M Russell (2/1/2012)
There is no concept of a "cell" in SQL Server. Are you talking about SQL Server or Excel?
I see what you are asking...
--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)

February 1, 2012 at 9:20 pm

#1441527
RE: Need Query Help Urgent

Heh... Actually, that (the code above) takes 3-4 seconds on my machine on a mere million rows. That's just too slow. Here are two other solutions that work...
--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)

February 1, 2012 at 8:25 pm

#1441522
RE: Need Query Help Urgent

Suresh,
Heh... ok... now you've found out two things. That the word "urgent" has become a bit of a taboo word on these forums and that you need to make...
--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)

February 1, 2012 at 7:18 pm

#1441517
RE: How to purge all but the top N rows from a table

Rod at work (2/1/2012)
At this point I don't have any data at all in the table, SQLKnowItAll, so I can be flexible as to how I handle this.
In that case,...
--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)

February 1, 2012 at 3:36 pm

#1441468
RE: hierarchyid barking up the wrong tree?

drew.georgopulos (2/1/2012)
We decided that because there was no containership expressed by the BETOS scheme, it was not worth the effort of coding the rows to show their lefts and rights.
Instead,...
--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)

February 1, 2012 at 3:03 pm

#1441456
RE: hierarchyid barking up the wrong tree?

GSquared (2/1/2012)
Jeff Moden (2/1/2012)
drew.georgopulos (1/31/2012)
thanks very much
i just did, and it seems to be exactly the right model for this; as you observed, updates are rare, the levels are...
--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)

February 1, 2012 at 3:02 pm

#1441455
RE: hierarchyid barking up the wrong tree?

drew.georgopulos (1/31/2012)
thanks very much
i just did, and it seems to be exactly the right model for this; as you observed, updates are rare, the levels are static, and 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)

February 1, 2012 at 5:38 am

#1441156
RE: Are the posted questions getting worse?

Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
It's a frequent story...
--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)

January 31, 2012 at 4:32 pm

#1441008
RE: Are the posted questions getting worse?

Capt. Sigerson (1/30/2012)
As someone with lots of DBMS experience, but new to SQL Server, I have found the SSC community to be an invaluable resource. I try to use...
--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)

January 31, 2012 at 3:13 pm

#1440988
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/31/2012)
SQL Kiwi (1/31/2012)
Ok, the embedded quotes occupy a whole screen now...
I need a filter to whack multiple embedded quotes. It can be quite annoying.
I think...
--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)

January 31, 2012 at 3:07 pm

#1440986
RE: how write split function for this store procedure

er.sivaganesh (1/31/2012)
i found the solution for my problem anyway thank u every one for sending our valuable time for me
Thats nice. Two way street...
--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)

January 31, 2012 at 3:04 pm

#1440985
RE: Numerical datatypes & the quirkiness within

A simple example of when you'd need to divide currency by currency is to determine profit margin. How much did you sell it for divided by how much you...
--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)

January 31, 2012 at 7:24 am

#1440624
RE: Where do you save your Create By/Date and Modify By/Date information?

GSquared (1/30/2012)
Personally, I consider this pattern of data auditing to be more harmful than helpful. It gives the apparency of auditing without the actuality of it. It does let you...
--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)

January 30, 2012 at 1:20 pm

#1440220
RE: Automate Restore 1

How about you, Steve? Has anyone done the article for this that you know of?
--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)

January 30, 2012 at 10:26 am

#1440141

Viewing 15 posts - 31,291 through 31,305 (of 59,101 total)