Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,736 through 39,750 (of 59,072 total)

RE: Temp DB Issue

You bet. Thanks, MJ.
--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 17, 2010 at 2:45 pm

#1120488
RE: Too much time to commit the transaction

CirquedeSQLeil (2/17/2010)
Hmmm. I like Jeff's idea. I also like Emmitt's idea. Is this database starting fresh? Are the triggers truly needed for this data load?
If 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 17, 2010 at 1:50 pm

#1120442
RE: Too much time to commit the transaction

My recommendation would be for you to post the transform script and the trigger. Let's see what we can do to convert this to a set based process and...
--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 17, 2010 at 5:46 am

#1119981
RE: Too much time to commit the transaction

How many indexes do you have? How many are out of order compared to the order of the inserts? And why are you trying to insert 10 million...
--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 16, 2010 at 8:50 pm

#1119799
RE: Repeated questions on forums

mohammed moinudheen (2/16/2010)
I have come across several cases where the questions are getting repeated very often on forums.
Is there anyway this could be avoided. Like if we can maintain an...
--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 16, 2010 at 7:50 pm

#1119782
RE: How To insert between Records

Hamid-Sadeghian (2/16/2010)
Because in my country the finance organs need to sequence the voucher number.
for now, i create a temp table and insert all the vouchers into temp table. then select...
--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 16, 2010 at 7:43 pm

#1119779
RE: How To insert between Records

John Esraelo-498130 (2/16/2010)
hamid, salam.. do not translate farsi to english directly.. because you might confuse the readers..
if you want you can write in FarsEnglish and I can translate that for...
--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 16, 2010 at 7:40 pm

#1119777
RE: How To insert between Records

John Esraelo-498130 (2/16/2010)
I think in normal accounting, at least in usa, there is a void process that can cancel.. in fact.. any checking account can handle that therefore it should...
--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 16, 2010 at 7:37 pm

#1119774
RE: If Else Statment Syntax Error

LOOKUP_BI-756009 (2/16/2010)
Can someone tell me why am I getting error mssg as following
Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'IF'.
DECLARE @minutes INT, @word VARCHAR(255),@hours INT,...
--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 16, 2010 at 7:14 pm

#1119767
RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

I'm thinking that it will all boil down to the video card which is likely quite a bit cheaper on the server than on anything else. It takes time...
--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 16, 2010 at 6:45 pm

#1119756
RE: Hardware Requirements

I don't have an answer to your good question but you might also want to throw in a note about how many users are going to be hitting this server...
--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 16, 2010 at 6:41 pm

#1119753
RE: WILD REPLACE ?

It does sound like fun. Thanks for the feedback. 🙂
--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 16, 2010 at 6:34 pm

#1119748
RE: DBCC Timewarp

Steve Jones - Editor (2/10/2010)
Can we perhaps send the customers and OPs through DBCC TimeWarp instead? Move them to tomorrow, 2020?
Nah... make that 1920... don't have to look forward 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)

February 16, 2010 at 5:54 pm

#1119742
RE: WILD REPLACE ?

C# Screw (2/16/2010)
Thanks Jeff
appologies for the delay...
When I get a moment I might try and build a function that fully supports the PATINDEX sytax.
I agree with Barry on this... 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)

February 16, 2010 at 1:10 pm

#1119488
RE: Problem in calculating missing periods

Thanks for the feedback, Surya. I do recommend that you reconsider the form of your Periods table as I demonstrated. It will likely make your life a lot...
--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 16, 2010 at 6:07 am

#1119219

Viewing 15 posts - 39,736 through 39,750 (of 59,072 total)