Viewing 15 posts - 31 through 45 (of 145 total)
Sergey Vavinskiy (10/2/2009)
October 4, 2009 at 5:46 am
"does not work" - give us more information about the problem
October 1, 2009 at 11:38 pm
1) transactional replication
2) backup/restore
3) "handmade" tool
October 1, 2009 at 11:35 pm
you can used SSMS to script them
October 1, 2009 at 4:33 pm
triggers are bad - because ... they are really hard to managed in big database
October 1, 2009 at 4:29 pm
are you updated statistics lately ? if no - you should, it may help!
October 1, 2009 at 4:15 pm
using query hints is not a good idea!
today I was doing some optimization on one of my clients env and (this is medium DW app - about 1TB of data)...
October 1, 2009 at 4:14 pm
you can use a Maintanence plan too - it is good for beginners 😉
good luck!
October 1, 2009 at 4:04 pm
Jeff - so in your opinion using star in exists/no exists queries is bad? (or something more then a bad habit?)
September 12, 2009 at 3:00 am
do you have on this new SQL 2005 all "server objects" you need ?
- logins
- jobs
- linked server
...
September 11, 2009 at 5:22 pm
if version means build : select @@version
September 11, 2009 at 5:20 pm
add the network pafh as a backup device through UI or sp_addumpdevice
September 11, 2009 at 5:19 pm
hi,
give us more information - what feature do you use to import data ?
what SQLFILENAME.sql contains ?
September 11, 2009 at 5:18 pm
you have a large number of VLF's because you badly mange your log files.
1) you shouldnt shrinkt it
2) log file should have "stable" size
3) 530vlf ? you are using autogrowth...
September 11, 2009 at 4:26 pm
Viewing 15 posts - 31 through 45 (of 145 total)