Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,661 through 36,675 (of 59,099 total)

RE: (sql 2008) t-sql concurrency question.

Heh... I'm just a step behind you on my posts...
--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)

September 19, 2010 at 8:20 pm

#1223766
RE: (sql 2008) t-sql concurrency question.

Craig Farrell (9/19/2010)
Ah, that makes sense, you're avoiding the necessity of the double call by using the running total method that's undocumented.
Btw, if you force the tablockx, you...
--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)

September 19, 2010 at 8:18 pm

#1223765
RE: (sql 2008) t-sql concurrency question.

Ah... to be sure... the "Kalpa Shah" that I refer to in the revision history was one of the two Systems DBA's I was working with on this problem. ...
--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)

September 19, 2010 at 8:15 pm

#1223762
RE: (sql 2008) t-sql concurrency question.

It's the combination of SELECT/UPDATE inside of an explicit transaction that produces the deadlocks just like at the company I was telling you about. If the following is kept...
--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)

September 19, 2010 at 8:05 pm

#1223759
RE: Need to zip and move C2 level audit files

Heh.. been there and done that. Use to work for a "little" DOD shop known as Raytheon. 😛
The only way that I can think of to make this synchronus...
--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)

September 19, 2010 at 7:41 pm

#1223754
RE: Pulling Filename from Windows directory into table

brianparow (9/19/2010)
What I'm trying to do is grab the filenames from a directory and see if there are 2 files with the same name and different extensions..
ie:
123.txt and 123.pdf
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)

September 19, 2010 at 7:20 pm

#1223753
RE: Large Chunks of Data

Craig Farrell (9/19/2010)
...think that old guy with the cell phone you can use as a doorstop... 🙂
Hey now! Watch it! I strongly resemble that remark! 😛
--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)

September 19, 2010 at 6:54 pm

#1223749
RE: (sql 2008) t-sql concurrency question.

Dang... I reviewed an article for someone on Sequence tables and now I can't find it.
At any rate, the WORST thing you could possibly do is use a BEGIN TRANSACTION...
--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)

September 19, 2010 at 6:52 pm

#1223748
RE: (sql 2008) t-sql concurrency question.

I'm not sure (CRS), but I think Paul White may have written an article on this subject. I'll see if I can find 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)

September 19, 2010 at 6:42 pm

#1223747
RE: (sql 2008) t-sql concurrency question.

Barkingdog (9/19/2010)
Craig,
You wrote
>>> CREATE TABLE FooBar (FooBarID INT IDENTITY( 1, 1), <tabledef>) should work just as well. If it's a matter of needing to know the ID for multiple inserts,...
--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)

September 19, 2010 at 6:39 pm

#1223746
RE: Deadlocking in stored proc calls (sql 2008)

I don't know if it will help your deadlock situation but you're asking for a world of hurt with how you're doing the deletes. If you look in Books...
--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)

September 19, 2010 at 6:31 pm

#1223744
RE: Why to check after every sql query IF @@Error = 0 ?

To add to what Adi has already stated, in SQL Server 2000, SET XACT_ABORT ON became one of my very best friends as a not-so-good attempt at Try/Catch. 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)

September 19, 2010 at 5:48 pm

#1223738
RE: What was my very first post?

GilaMonster (9/19/2010)
Steve Jones - Editor (9/18/2010)
I think most of us would be hard pressed to impress Gail in an interview :w00t:
Nah. Know what you claim to know and show some...
--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)

September 19, 2010 at 5:41 pm

#1223737
RE: Transform Data / Duplicate Records on the Fly

david.c.holley (9/19/2010)
I just came to the stunning realization that I could greatly streamline the overall performance by using the tally table to determine the color of the individual cells instead...
--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)

September 19, 2010 at 5:21 pm

#1223733
RE: Need to zip and move C2 level audit files

shew (9/19/2010)
Looping is not the issue. Zipping is the issue. Do you know of a way to zip a file using native Windows Server commands, without having to install any...
--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)

September 19, 2010 at 5:10 pm

#1223730

Viewing 15 posts - 36,661 through 36,675 (of 59,099 total)