Viewing 15 posts - 256 through 270 (of 441 total)
Dev team have no idea,
is it possible to pull out the name of the service?
SueTons.
February 15, 2013 at 8:14 am
anthony.green (2/15/2013)
We get that a lot due to SQL dependencies when our message broker service stops and starts, as it drops and recreates...
February 15, 2013 at 7:08 am
Akkare (2/11/2013)
Microsoft suggests 10 databases to be mirrored in a single instance, but I have seen more. I guess there will be...
February 13, 2013 at 5:28 pm
sdpages (2/10/2013)
I change the Database Recovery Model to [Bulk Logged Mode] before I run by REBUILD INDEX job . After the RE-Index is done the database is put back to...
February 10, 2013 at 7:32 pm
opc.three (2/9/2013)
log shipping will be fine. clustering and mirroring need more attention due to failover scenarios. also check for running Agent jobs.
As far as jobs, I will stop the agent...
February 9, 2013 at 8:10 am
opc.three (2/9/2013)
February 9, 2013 at 7:56 am
Richard Fryar (2/8/2013)
February 8, 2013 at 6:33 pm
Richard Fryar (2/8/2013)
This script checks all databases in one go, and avoids use of a...
February 8, 2013 at 12:25 pm
Perry Whittle (2/1/2013)
SQLCrazyCertified (2/1/2013)
DECLARE fixusers CURSORFOR
SELECT UserName = name FROM sysusers
WHERE issqluser = 1 AND (sid IS NOT NULL AND sid <> 0x0)
This first part declares a cursor checking...
February 8, 2013 at 8:15 am
Just to update you guys, here is what I found.
Whatever was blocking last night went away, I was able to access the database today. I found the log grew...
February 7, 2013 at 9:19 pm
anthony.green (2/7/2013)
Depends, if you have enterprise edition you can do you rebuilds online, providing that the index columns are of a compatable type, but usually do it out of hours.
Another...
February 7, 2013 at 6:12 am
anthony.green (2/7/2013)
Depends, if you have enterprise edition you can do you rebuilds online, providing that the index columns are of a compatable type, but usually do it out of hours.
Ok....thank...
February 7, 2013 at 5:20 am
GilaMonster (2/7/2013)
Ignore the GUI, it's half-broken.Query sys.dm_db_index_physical_stats for that table, that'll give you all the info the gui would.
To rebuild - ALTER INDEX ALL ON <table> REBUILD
Thanks guys,
Is rebuilding index...
February 7, 2013 at 5:12 am
JeremyE (2/5/2013)
Check out sysjobs and sysjobsteps in the msdb database.
Does anyone have any script for this?....Basically, I am looking for a script to get all the jobs with job names...
February 5, 2013 at 3:23 pm
Perry Whittle (1/31/2013)
SQLCrazyCertified (1/29/2013)
Hi, Thanks for both of your replies.I have fixed the issue by doing couple of more log backups then I shrank and it worked.
You have cycled the...
January 31, 2013 at 9:21 am
Viewing 15 posts - 256 through 270 (of 441 total)