Viewing 15 posts - 706 through 720 (of 1,524 total)
Interesting. However, the SAN team tells me.. if we had problems with the SAN or connectivity many other larger systems not on SQL Server would be complaining up and...
November 6, 2012 at 8:58 am
Correct. By stopping SQLAgent service no jobs will run. Then you restore msdb database from a good db backup, then start SQLAgent.
run the CHECK Integrity again to make...
November 2, 2012 at 6:26 am
Find out which SPID it is using and do a SP_WHO2 xxx where xxx is the SPID of the running query. Run this a few times...
November 2, 2012 at 6:20 am
TEMPDB files can grow quite large due to sorts and temp tables.
October 26, 2012 at 8:28 am
Meet George Jetson (10/26/2012)
Gail - what if it were a system database, in particular the master database?
THe master database will probably never grow. All it holds is logins and...
October 26, 2012 at 8:23 am
Another thing to look at the database character set and collation. Make sure they are all the same. There 'can' be problems if you move a database with...
October 26, 2012 at 6:04 am
GilaMonster (10/23/2012)
Check the SQL error log, see what's the last few entries in the...
October 25, 2012 at 8:33 am
That was a crazy game last night, wow, the Giants made a statement in game 1.
October 25, 2012 at 5:29 am
Jan Van der Eecken (10/23/2012)
BTW, I still haven't understood why it is called the "World...
October 23, 2012 at 10:26 am
calvo (10/23/2012)
The Giants came back from a 3-1 deficit and emphatically defeated...
October 23, 2012 at 9:11 am
If you have a massive amount of rows you are deleting rebuild the indexes after that. That will free up your space.
October 23, 2012 at 5:53 am
They won three straight against my Red's... LOL...
We shall see. I am rooting for them... Getting tired of seeing Cardinals go deep into the playoffs so often.
October 22, 2012 at 10:19 am
SQLDCH (10/19/2012)
Giants aren't fairing much better. Hope I we get to see them come home, at least.
looking more like a Cardinal / Tigers series... rematch of 1967/2006.
Go Tigers! ...
October 19, 2012 at 12:08 pm
sqldba4u (10/18/2012)
Markus (10/18/2012)
sqldba4u (10/18/2012)
So that's the only reason for the locking of the login?
If you have the 'Enforce Password Policy' checked and that user then puts the password in incorrectly...
October 18, 2012 at 8:40 am
sqldba4u (10/18/2012)
So that's the only reason for the locking of the login?
If you have the 'Enforce Password Policy' checked and that user then puts the password in incorrectly more times...
October 18, 2012 at 8:07 am
Viewing 15 posts - 706 through 720 (of 1,524 total)