Viewing 15 posts - 4,681 through 4,695 (of 5,843 total)
Pretty poor that this value ISN'T stored and reused if you ask me - or even if you don't!! 😛
June 23, 2009 at 1:22 pm
tom.groszko (6/22/2009)
You said nothing about checking security. I still find SQL servers with a default blank password. Everybody who ever worked there has full access to the server.Tom Groszko
'Fixing' security...
June 22, 2009 at 9:03 am
stevecurtis3 (6/22/2009)
June 22, 2009 at 7:16 am
1) I agree with Mark about Drop obsolete objects. It is virtually impossible to find and properly scan all code that might run against any given database that might...
June 22, 2009 at 6:55 am
The main area where you can get in trouble with forced parameterization is when you have lots of calls against values that have widely disparate numbers of rows hit, especially...
June 11, 2009 at 8:16 am
Rob Reid (6/10/2009)
June 10, 2009 at 1:20 pm
Dave Ballantyne (6/8/2009)
Why not avoid the issue altogether , and do the work in one statement ?UPDATE AccountCounter
SET AccountNumber = AccountNumber+1
Output inserted.AccountNumber
WHERE objid = @currentObjID
I think that will require...
June 10, 2009 at 12:17 pm
Novel suggestion: why don't you actually find out what is causing the problem, and then try to fix that? 😀
Seriously, monitor the various Perf Mon counters...
June 10, 2009 at 12:14 pm
There are several 3rd party auditing products - ApexSQL and RedGate both have them IIRC. I think Paul Randall wrote a freebie script that will create the necessary triggers...
June 10, 2009 at 12:06 pm
ALZDBA (6/10/2009)
It cannot be sql2008 ...... the feedback registration date is 11/26/2006
I believe you are mistaken if you think that MS wasn't working on SQL Server 2008 in late 2006.
June 10, 2009 at 5:16 am
Were your physical disk counters for each individual drive?
Spurious IO delays during high activity can be expected and really aren't an issue as long as they are very limited...
June 5, 2009 at 9:57 am
I wonder if the ONLINE part of this is causing lots of extra tlog activity. See here, ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/eef0c9d1-790d-46e4-a758-d0bf6742e6ae.htm and here ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d82942e0-4a86-4b34-a65f-9f143ebe85ce.htm in BOL and also follow the various links...
June 5, 2009 at 9:51 am
Mad Hacker (6/4/2009)
The vast majority of the SSC Community truly appreciate your efforts, including any occasional errors that might be made. I would think that a "newbie" would have...
June 5, 2009 at 9:27 am
search the web to find Paul Randall's blogs about dbcc checkdb. He litterally worked on that code in the engine at Microsoft. I also recommend you hire a...
June 5, 2009 at 8:43 am
Gail is right - if 354 and 291 milliseconds are sustained values for writes/reads then you have a serious problem. If they occurred during a 2 minute period of...
June 5, 2009 at 8:41 am
Viewing 15 posts - 4,681 through 4,695 (of 5,843 total)