Viewing 15 posts - 9,226 through 9,240 (of 9,244 total)
set the recovery model to "bulk logged" during the purge and change back to simple after you have finished deleting data
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2008 at 4:24 am
exactly, BTW also forgot to mention that sa login is also disabled on our sql servers.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 3:48 pm
even under virtualisation 64bit isnt necessarily the defacto platform
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 3:38 pm
assuming you have the arrays available 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:15 am
humbleDBA (6/18/2008)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:13 am
just for reference and to help others with similar problems what was it you did? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 8:05 am
what monitoring tool(s) are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 18, 2008 at 7:56 am
our databases all get set to SA ownership and SA has a secure password.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:36 am
done this already, use xp_regread to read the values from the registry and output
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:32 am
depending what you are auditing, there would be more options of tracing but you need advanced auditing enabled
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:17 am
the IP address of the machine would also be recorded with the SQL login, depends what you are auditing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 12, 2008 at 11:17 am
detach and re attach, also dont forget to script off your logins and take those across too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2008 at 8:43 am
Viewing 15 posts - 9,226 through 9,240 (of 9,244 total)