Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,426 through 43,440 (of 59,097 total)

RE: High volume of transactions definition/measure?

I guess my question would be, why do people try to quantify such things a low or high? If your hardware and database server can't handle it, then it'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)

June 13, 2009 at 11:50 am

#1009130
RE: Append output from SQLCMD in batch file

WayneS (6/12/2009)
Ahem. It's not very often that someone gets to tell Jeff that he's wrong, AND can prove it...
Heh... wrong for what? If you want to keep 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 13, 2009 at 11:40 am

#1009128
RE: Triggers

vishal_mca2005 (6/13/2009)
Thanks Jeff Moden,
Thank u very much for my help
Thank you 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)

June 13, 2009 at 11:25 am

#1009122
RE: Restrict log file size (SQL server 2005)

dxmer (6/13/2009)
Wow, a further explanation that doesn't address the question.
Wow... another smart a$$ed and incorrect comment. I was wrong before... you and your cruddy attitude should leave.
--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 13, 2009 at 11:19 am

#1009120
RE: What SQL Server Sites do you use?

GilaMonster (6/13/2009)
Lynn Pettis (6/13/2009)
Who decides who can vote and who can't, Steve?
Exactly the problem.
SO attempts to solve that by giving points for 'good' and 'correct' answers, 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)

June 13, 2009 at 11:13 am

#1009119
RE: Random problems

benoit.rocco (6/13/2009)
I was using SQL Server Management Studio, but connected to a SQL2000 server, it's for that reason the function ROW_NUMBER() didn't exist ^^
Ah... thank you Benoit. That...
--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 13, 2009 at 11:08 am

#1009115
RE: Placing tables in memory

Paul White (6/13/2009)
You could also put tempdb on a RAM disk.
Heh... I always forget the simple stuff. 😀
--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 13, 2009 at 11:06 am

#1009112
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

I guess the next question would be, how "real time" does the running total thingy need to be? We might be able to eliminate the need for the cursor...
--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 13, 2009 at 11:01 am

#1009108
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Ok folks... NOW you can test for performance because NOW you can generate substantial amounts of test data quite easily. The following code creates a million rows of randomized...
--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 13, 2009 at 10:52 am

#1009104
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Aaron (6/13/2009)
That's good feedback.
Heh... I've found that many concurrency issues simply vanish in the presence of high speed code. What I'd be interested in is how fast the trigger...
--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 13, 2009 at 10:07 am

#1009097
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Paul White (6/13/2009)
Jeff Moden (6/12/2009)
It causes the whole thing to act like a cursor with a recomplile for every row if you don't include the target table in the FROM...
--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 13, 2009 at 9:57 am

#1009094
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Aaron (6/13/2009)
PS: Why go through all of the trouble creating this code and formatting it if it's just going to get hosed. I attached a text file with the formatting...
--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 13, 2009 at 9:53 am

#1009093
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Aaron,
The post Paul White wrote that starts with "I would usually write it like this:" is more of what I would have done and for the same reasons. That...
--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 13, 2009 at 9:48 am

#1009092
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Aaron (6/13/2009)
Is there a way I can increase performance for concurrency by making the database's isolation level to "READ UNCOMMITTED"? Or is there a way to do this just...
--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 13, 2009 at 9:45 am

#1009091
RE: What SQL Server Sites do you use?

Heh... wasn't talking about SO. I was talking about here. And by heavy hitters, I'm not necessarily talking about folks with a lot of points. I'm talking...
--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 13, 2009 at 12:36 am

#1009018

Viewing 15 posts - 43,426 through 43,440 (of 59,097 total)