Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,506 through 23,520 (of 59,102 total)

RE: Huge TempDb file on a Development server

My suggestion would be to find out what actually made it grow so quickly. If someone did something in coded that's getting ready to go to prod, you could...
--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)

June 3, 2014 at 12:25 am

#1718411
RE: t-sql 2008 exlain select

sgmunson (5/30/2014)
Jeff Moden (5/30/2014)
Heh... not to worry. I started out by testing the other solutions and then went back to the original solution. I kept looking at 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)

June 3, 2014 at 12:21 am

#1718410
RE: SQL query where value is less than negative number not giving expected results

Try it without the quotes around the numeric constants.
--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)

June 3, 2014 at 12:14 am

#1718409
RE: uses of string splitters

KoldCoffee (6/2/2014)
Seriously? No one could answer that question?
Heh... Seriously? You couldn't answer that question? 😉 Keep it light, KC.
Look at the code again. You've taken 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)

June 3, 2014 at 12:06 am

#1718407
RE: how to remove next and previous record is amount = 0?

Unless this was an accidental duplication of data, there's no way that I'd do this. You're destroying historical data.
--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)

June 2, 2014 at 11:59 pm

#1718406
RE: Concat parameter in a message

Koen Verbeeck (6/2/2014)
Parameters cannot be expressions.
http://stackoverflow.com/questions/12009832/how-to-concatenate-string-when-setting-a-parameter-in-transact-sql
Specify Parameters
That's step one, for sure. Step 2 is that the variable is assigned no value and will always return a NULL for 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)

June 2, 2014 at 3:44 pm

#1718382
RE: Cluster index fragementation

I just "Love" INT dates and times and the "new" datetime datatypes especially when someone wants to know the duration in decimal hours between a start and end date 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)

June 2, 2014 at 3:31 pm

#1718381
RE: Should your Source Control System understand your code?

There are some processes that are better left to humans than forms of automation. I find that many people mistake the term "Source Control" for "Configuration Management". While...
--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)

June 2, 2014 at 3:26 pm

#1718378
RE: View Server State permission

I don't know of any drawbacks or risks to security here. It may just be that they don't wqnt to get into the habit of responding to "mere" Developer...
--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)

June 2, 2014 at 3:03 pm

#1718373
RE: BULK INSERT with multiple character ROWTERMINATOR split in source

pogla.the.grate (6/1/2014)
UPDATE
The code used for this output is an Oracle Spool Command (don't ask, it's a long story).
The linesize property in the Spool Command was set to 2000, where as...
--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)

June 2, 2014 at 6:06 am

#1718166
RE: Not Exists

I second Gail's question. Why are you looking to replace WHERE NOT EXISTS? Unless there's a performance or resource usage problem with it (which might just need a...
--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)

June 1, 2014 at 10:49 am

#1718072
RE: Cannot attach sql 2005 database to sql 2008

It's saying pretty much what the problem is. Go back to 2005 and find the read-only files.
--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)

May 31, 2014 at 1:20 pm

#1718033
RE: Sp & parameters

How much longer? And how long does the longest run take.
--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)

May 31, 2014 at 1:15 pm

#1718031
RE: Sp & parameters

ramana3327 (5/31/2014)
I am wondering that usually when we execute the stored procedure several times. The execution time should be less but in my case the execution time is taking longer....
--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)

May 31, 2014 at 10:54 am

#1718017
RE: ER Diagram

On the first 2, look at the crows feet. They tell the 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)

May 31, 2014 at 12:37 am

#1718008

Viewing 15 posts - 23,506 through 23,520 (of 59,102 total)