Viewing 15 posts - 47,176 through 47,190 (of 49,571 total)
Christopher G.S. Johnson (3/18/2008)
Any thoughts on the order of maintenance plan operations - optimization, integrity check and backups?
That should be fine. Just make sure shrink isn't included in...
March 18, 2008 at 9:36 am
What do the execution plans look like?
If you can post the script of the proc and the schemas of the tables (with index definitions), we can offer suggestions.
March 17, 2008 at 1:51 pm
Personally I'd recommend finding the cause of the deadlocks and resolving that (usually bad code or bad indexing) rather than putting nolock everywhere. It can have some interesting effects (read...
March 17, 2008 at 1:48 pm
Litespeed's pretty good. It's used at my company and we haven't had an issue with it.
Regarding the tape backups, test them, test them and test them again. Tapes do fail....
March 17, 2008 at 1:45 pm
I'm so used to the output of 1204 that it's not a challenge to read anymore. Could be that this is not a good thing.
Is the output of 1222...
March 17, 2008 at 1:39 pm
Do you have a previous database backup?
Run the following and see what it says.
DBCC CHECKDB ('MyDB') with no_infomsgs
March 17, 2008 at 1:36 pm
Ack. That should be the very last resort when all else fails, not the first thing to try.
The system tables should not be updated. Doing so can have nasty consequences.
March 17, 2008 at 5:44 am
It's a fairly big topic. Books online has a good coverage. Have a look through that, then if you have specific questions, post them here.
March 17, 2008 at 1:02 am
Jeff Moden (3/17/2008)
There's a whole lot of minor differences but the big difference is, table variables do not and cannot be made to use statistics.
Yup. And that, along with the...
March 17, 2008 at 12:28 am
If yu're using SQL 2005, you should avoid extended stored procs. They are deprecated. use CLR instead.
What does your extended proc do?
March 17, 2008 at 12:26 am
Is that account in the local administrators group?
Are you sure something else isn't connecting in? SQL Agent, MOM, anything like that?
March 17, 2008 at 12:08 am
Sure it's necessary. CheckDB checks to see if there's any corruption of any form in the database. Invalid checksums, bad page linkage, out of range column values, etc
I would suggest...
March 16, 2008 at 2:01 pm
You can also use profiler to detect deadlocks, but it requires running a constant trsace, which I prefer not doing.
Fixing deadlocks is a pretty wide topic. Generally bad code is...
March 16, 2008 at 1:59 pm
Yup, and it does work. Had to do that a couple months ago after someone removed builtin\admins without adding the DBA's windows group first. :hehe:
Shut down the SQL service (and...
March 16, 2008 at 7:06 am
Probably compatability mode. What do the following queries return?
SELECT @@version
exec sp_dbcmptlevel < Name of the database you're in >
March 16, 2008 at 6:58 am
Viewing 15 posts - 47,176 through 47,190 (of 49,571 total)