Jeff Moden

Forum Replies Created

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

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
RE: Sp & parameters

It turns out that we're not the first to encounter this lovely problem. There's been a CONNECT item open since 2006.
http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=234143
The reason I assumed it would work is because...
--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:13 am

#1718007
RE: Sp & parameters

Eirikur Eiriksson (5/30/2014)
Unfortunately that's not too useful, it will show if the parameter is nullable but that's about it.
I just love fully documented and supposedly supported features that don't 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)

May 30, 2014 at 11:49 pm

#1718003
RE: Aggregator transformation.....how to get all columns in output

sattar419 10789 (5/29/2014)
Hi all,
I am trying to use Aggregator transformation to do the sum on one column based on group by on another column, but when i do it i...
--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 30, 2014 at 11:39 pm

#1718001

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