Viewing 15 posts - 691 through 705 (of 8,416 total)
opc.three (5/2/2012)
Elliott Whitlow (5/2/2012)
But like most things SQL, it depends.
From what has been shared so far the use case presents itself squarely in SB's wheelhouse, but I will leave it...
May 2, 2012 at 12:01 pm
Elliott Whitlow (5/2/2012)
When you have to run that job every 1 minute or every 5 I'm thinking that method is less effective.
Perhaps. I think the last time I did...
May 2, 2012 at 9:08 am
GSquared (5/2/2012)
It would look something like that. Usually gets a very efficient execution plan.
Client ID would need to be a key to avoid duplicates there.
You could also add WITH...
May 2, 2012 at 9:05 am
Ben-425648 (5/2/2012)
May 2, 2012 at 7:24 am
The simplification you are expecting with OPTION (RECOMPILE) only works with SQL Server 2008 and later. This is known as the parameter embedding optimization - see http://blogs.msdn.com/b/grahamk/archive/2009/11/18/changed-behaviour-of-option-recompile-syntax-in-sql-server-2008-sp1-cumulative-update-5.aspx
Without this, the...
May 2, 2012 at 7:09 am
CELKO (5/1/2012)
CREATE TABLE Client_Interviews(client_id INTEGER NOT NULL
REFERENCES Clients(client_id),
interview_date DATE NOT NULL,
PRIMARY KEY (client_id, interview_date ));
That assumes client_id and interview_date is a key - what if clients can...
May 1, 2012 at 5:16 pm
opc.three (5/1/2012)
However The Ace is the relevant use case here, in my opinion.
It might be; I don't know enough about the requirement to say. That's why I said SB...
May 1, 2012 at 2:37 pm
The issue you are encountering is known as the 'lost update' problem. Alexander Kuznetsov has an excellent article that covers this topic well: http://www.simple-talk.com/sql/t-sql-programming/developing-modifications-that-survive-concurrency/
May 1, 2012 at 5:22 am
I would also strongly discourage the use of the OLE Automation procedures (especially with a cursor as in the demo code). Service Broker may also not be the best...
May 1, 2012 at 5:10 am
CREATE TABLE dbo.Employee
(
ID integer PRIMARY KEY,
Division ...
May 1, 2012 at 4:43 am
CREATE TABLE dbo.ClientDetails
(
ID integer NOT NULL,
ClientID ...
May 1, 2012 at 4:28 am
WayneS (4/21/2012)
April 21, 2012 at 8:14 pm
If SNAPSHOT had been one of the options, we could have had an interesting discussion over which is more strict.
Good question anyway, thanks!
April 19, 2012 at 9:58 am
SQLRNNR (4/19/2012)
Thanks for double checking my code. Too bad my results were wrong. There has got to be a way of doing this.
I agree, but we might have...
April 19, 2012 at 9:16 am
SQLRNNR (4/19/2012)
The query...
April 19, 2012 at 1:31 am
Viewing 15 posts - 691 through 705 (of 8,416 total)