Viewing 15 posts - 9,001 through 9,015 (of 9,023 total)
if you are going to shrink, at least do it after the index rebuild as pages will be moved around. If you specified a fill factor of 50 for instance...
July 10, 2008 at 10:13 am
pound for pound, i have found it quicker to detach copy then re attach databases rather than backup and restore. Also dont forget the microsoft scripts to export your logins...
July 10, 2008 at 10:07 am
how many servers\databases are we talking?
July 10, 2008 at 10:04 am
how many characters is the servername currently?
is the SQL server a member server or stand alone server
July 10, 2008 at 9:33 am
could it be that someone has configured an application\web site to use the SA account? either way assign an obscure password to the account and then disable it. Use the...
July 10, 2008 at 7:01 am
set the recovery model to "bulk logged" during the purge and change back to simple after you have finished deleting data
July 9, 2008 at 7:11 am
you would be wise to furnish sql server with more memory rather than CPU. High CPU count will raise the software costs too 😉
July 9, 2008 at 7:06 am
for SQL2000 try this, it returns any objects not owned by sys or dbo just change it to look for your login (instead of excluding). To catch all DB's wrap...
July 8, 2008 at 4:24 am
exactly, BTW also forgot to mention that sa login is also disabled on our sql servers.
June 18, 2008 at 3:48 pm
even under virtualisation 64bit isnt necessarily the defacto platform
June 18, 2008 at 3:39 pm
if you plan on using perfom there are a set of key counters to look at, what do you plan to use?
June 18, 2008 at 3:38 pm
assuming you have the arrays available 😀
June 18, 2008 at 8:15 am
I don't wholy disagree with you on the 64-bit vs 32-bit. In fact in most cases, and for DB servers that have large DBs and require performance then 64-bit...
June 18, 2008 at 8:13 am
just for reference and to help others with similar problems what was it you did? 😉
June 18, 2008 at 8:05 am
what monitoring tool(s) are you using?
June 18, 2008 at 7:56 am