Viewing 15 posts - 42,181 through 42,195 (of 49,571 total)
Pavas Malviya (12/22/2008)
Thank you for all the information...I think I need to use the extended proc
How's your C++ skills?
December 23, 2008 at 12:44 am
ramadesai108 (12/22/2008)
I still have a cursor
Why?
See my edited post above.
December 22, 2008 at 3:02 pm
ramadesai108 (12/22/2008)
Isn't it easier to use the 2 inserts based on the cursor values rather than doing a select as Gail pointed out?
Easier? Maybe. Slower? Definitely.
Also that update is running...
December 22, 2008 at 2:54 pm
leonp (12/22/2008)
Meanwhile, heres the question again, if these numbers look good, what is with the low PLE - 200.76?
Good question. The buffer cache hit ratio's high, so most pages SQL...
December 22, 2008 at 2:48 pm
I can't see any indications of poor IO performance from those stats.
December 22, 2008 at 2:32 pm
DBASkippack (12/22/2008)
We inadvertantly had 6 DB's DROPPED from a non-prod environment. How can I tell who (or what process) dropped them?
If you didn't have some trace running at the...
December 22, 2008 at 2:31 pm
Why are you using a cursor at all? The update doesn't reference the cursor row, meaning you're doing exactly the same update multiple times.
The two inserts can be done...
December 22, 2008 at 2:27 pm
HKwai (12/22/2008)
December 22, 2008 at 9:32 am
John (12/22/2008)
I was wondering if some form of a detach / re-attach would work from the other log shipped standby server at C.
Unfortunately not.
If you try to detach an...
December 22, 2008 at 9:28 am
Michael Earl (12/22/2008)
Don't bite my head off Gail,
Not biting anything
just wanted to make the point that it is logged "differently" without typing out a lot of detail.
Sorry, it's just...
December 22, 2008 at 9:09 am
Perry Whittle (12/22/2008)
Ahmad Osama (12/22/2008)sqlcmd -S BUILDSERVER -E
is BUILDSERVER the correct instance name?
It's the servername of the server that he's starting in single user mode. Check the attached error log...
December 22, 2008 at 8:42 am
Ok. Confirm the following for me.
1) You have stopped the service.
2) You have one command window open where you ran sqlservr -m and then left it running
3) You are running...
December 22, 2008 at 8:38 am
Michael Earl (12/22/2008)
TRUNCATE is a non-logged operation, so if you are using log shipping or have regular log backups running, it can cause you some issues.
Not at all.
Truncate table...
December 22, 2008 at 8:37 am
HKwai (12/17/2008)
Does anyone know of a solution to this?
EXECUTE AS
December 22, 2008 at 8:33 am
Peso (12/22/2008)
Doesn'tIF UPDATE(colStatus)
do that for you?
That just checks if the column was referenced in the update statement. If the column is updated to itself, UPDATED will be true...
December 22, 2008 at 8:28 am
Viewing 15 posts - 42,181 through 42,195 (of 49,571 total)