Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,631 through 36,645 (of 59,072 total)

RE: Will inserting an IDENTITY PK leave row order unchanged?

I was going to suggest that if the app likes the "natural" order up to now, have the app read the data from the table into a new table 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)

September 19, 2010 at 8:36 pm

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

Barkingdog (9/19/2010)
Jeff,
You wrote
>>> At any rate, the WORST thing you could possibly do is use a BEGIN TRANSACTION on this problem.
Why is that the case?
In fact, my solution is exactly...
--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:32 pm

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

Barkingdog (9/19/2010)
Jeff,
My solution is the same as yours except I used:
SELECT @return= NextID FROM seqNum with (UPDLOCK)
Given the table has only a single record I think the solutions are equivalent....
--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:28 pm

#1223769
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

Viewing 15 posts - 36,631 through 36,645 (of 59,072 total)