Viewing 15 posts - 42,196 through 42,210 (of 49,571 total)
subha.v (12/22/2008)
Advanced thaks for all.I didn't expect this much reply from my post. It's really helpful for me to know more about the problem.
If you answered all the questions we've...
December 22, 2008 at 8:23 am
Perry Whittle (12/22/2008)
are you sure
NET STOP MSSQLSERVER
is stopping the correct instance?
It's the same instance that he's starting and the same one he's connecting to via sqlcmd. Whether it's...
December 22, 2008 at 8:20 am
Paul (12/22/2008)
From what I've read, there's an overhead associated with checking for locks that you incur even if there aren't any.Adding NOLOCKS is supposed to skip that.
Very small overhead.
December 22, 2008 at 6:32 am
subha.v (12/22/2008)
Sorry. I am waiting for my PL approval.
?
Could you please confirm is searching based on the non-clustered index cause the performance problem.
No. Not enough information.
December 22, 2008 at 6:16 am
Paul (12/22/2008)
I meant that the data is updated so infrequently that I dont think the costs of record locking outweigh the performance gain from ignoring it.
Thing is, if using nolock...
December 22, 2008 at 6:15 am
Ok. Is there a question somewhere in that?
If you want assistance in writing the trigger, you're going to have to give a lot more details on what you want to...
December 22, 2008 at 5:48 am
ps (12/22/2008)
try reducing the frequency of tran log backups. this will flush out inactive transaction more frequently from the log file.
Other way around. Reducing the frequency of the log backups...
December 22, 2008 at 5:43 am
What recovery model and how often are you doing transaction log backups?
What do you mean by "unable to open it"?
Take a read through this - http://www.sqlservercentral.com/articles/64582/
December 22, 2008 at 5:28 am
So you've got the SQL service stopped, you've got one command window where you ran sqlservr.exe -m and left it running, and another command window where you're trying to connect...
December 22, 2008 at 5:25 am
nitinpatel31 (12/22/2008)
There must be some corruption in Index or Data pages.
If there was corruption of any form the query would not run forever. It would fail with an error,...
December 22, 2008 at 5:23 am
subha.v (12/22/2008)
It's still running. Nearly 55 min.
Is it blocked? Is it wating for a resource, if so what's the wait type and wait resource?
How many rows out of the 700000...
December 22, 2008 at 5:22 am
Jeff Moden (12/22/2008)
Ohhhhh.... that stuff..... gee... I wonder when they'll come out with an EDI data type? 😛
CREATE TYPE EDI
EXTERNAL NAME EDI.[PointlessClrTypes.EDI] ;
December 22, 2008 at 5:21 am
subha.v (12/22/2008)
Select ColB,ColC from table1 where ColD= 123.
How many rows will that return?
December 22, 2008 at 3:18 am
Kishore.P (12/22/2008)
> DBCC CHECKTABLE.
> DBCC UPDATEUSAGE ( ), if it is not a production server.
> DBCC CLEANTABLE
Why?
December 22, 2008 at 3:06 am
Viewing 15 posts - 42,196 through 42,210 (of 49,571 total)