Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,631 through 42,645 (of 59,067 total)

RE: mdf file increasing rapidly - what are the causes for increasing the mdf file size?

Lynn Pettis (7/31/2009)
How many times do you plan on posting this???
Multiple post, please post responses here.
Heh... not to worry, Lynn. It would appear that a good number of folks...
--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)

July 31, 2009 at 7:53 pm

#1033238
RE: IF Statements affecting performance ?

Heh... Gail took the words right out of my mouth.
Post your code and let's have a look-see.
--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)

July 31, 2009 at 7:51 pm

#1033237
RE: Display address in vertical format

What do you mean by a single "attribute"? Do you mean it's all a single string to begin with?
--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)

July 31, 2009 at 7:50 pm

#1033235
RE: Unable to start T-SQL Debugging

Sorry, Scott... I've got nothing for you on this. My response will serve to "bump" your question again and your question gives me yet another reason to avoid CLR's....
--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)

July 31, 2009 at 7:44 pm

#1033234
RE: Loading Data from Text file to SQL Server

apat (7/31/2009)
Thanks for the help... it worked...
It worked? Which of Rupashri's SSIS suggestions worked?
--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)

July 31, 2009 at 7:33 pm

#1033231
RE: Replace @@identity with SCOPE_IDENTITY() in all stored procedures

Jack Corbett (7/31/2009)
While you will be better off with SCOPE_IDENTITY() in place of @@Identity you need to be aware that there is a bug in SCOPE_IDENTITY(). See this post.
With...
--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)

July 31, 2009 at 7:23 pm

#1033229
RE: Calculating custom score

Matt Wilhoite (7/31/2009)
Here is what I did. There is probably a better way but this was the first thing that came to mind.
Nice... the optimizer is also smart enough...
--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)

July 31, 2009 at 6:54 pm

#1033226
RE: Query Help

Allister Reid (7/31/2009)
Hi,
here is a solution that relies on a tally table http://www.sqlservercentral.com/articles/T-SQL/62867/ and is based upon the code in http://www.sqlservercentral.com/articles/Crosstab/65048/, these are two excellent articles, and I recommend them...
--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)

July 31, 2009 at 6:31 pm

#1033225
RE: Chaning SA Password

Heh... whatever you do, remember what the old password was so you can reuse it if all hell breaks loose. 😛 Yeah... I know... how obvious can I be?...
--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)

July 31, 2009 at 6:29 pm

#1033224
RE: Query Performance is very slow

balbirsinghsodhi (7/31/2009)
Wish, I had three eyes, looks like two eyes are not enough.
Thanks guys.
Heh... that's why I wear glasses... it sometimes takes "four eyes". 😛
--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)

July 31, 2009 at 6:23 pm

#1033223
RE: Import Performance

I believe the two methods use two different drivers.
--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)

July 31, 2009 at 6:21 pm

#1033221
RE: Display hyperlinks in results

I don't believe so... not from SSMS anyway...
--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)

July 31, 2009 at 6:17 pm

#1033220
RE: delete duplicate records based on unique keys
I believe this is what shamassaeedmr was after... it doesn't require a temp table, it leaves only the required rows, and it's nasty fast...
```
--===== As the others have done, create...
```
--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)
July 31, 2009 at 5:58 pm

#1033218
RE: delete duplicate records based on unique keys

shamassaeedmr (7/31/2009)
try this one
i want to delete the duplicate records based on regno and leavetypeid. Output should be like this:
Delete from
(
Select rank() over (partition by regno,leavetypid order by regno)...
--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)

July 31, 2009 at 5:21 pm

#1033211
RE: How come I can't delete my topics?

There was a rash of people deleting their original posts once they had an answer. There were also some people who started deleting their own posts because they got...
--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)

July 31, 2009 at 5:03 pm

#1033208

Viewing 15 posts - 42,631 through 42,645 (of 59,067 total)