this is really a simple t sql programming task. read the directory into a table, extract the date from the filename, delete where date > 3 days old....

apart from suggesting not to do network backups, I seem to recollect that you need to run your sql server service account as administrator to make this work. Local system...

the most important factor with x64 is that you MUST set the max memory otherwise you'll have big problems. Lock pages in memory can be useful, 16Gb on x64 isn't...

60 ints is a tiny table - don't make work - only consider vertical partitioning if you have real serious reasons to do so - it's bit like over...

this isn't a plug for my blog, but I've been actually testing 3 sans for performance as part of a data centre move, becuase of a nda I can't name...

I do think a read of a good admin book would be useful; however - your mdf won't shrink even when empty unless you have autoshrink on, which I hope...

I usually run tempdb with files = number of proc cores/2. Once I decide what the usual growth is I fix the file sizes so that tempdb does not normally...

I don't want to be rude here guys but talk about the blind leading the blind!! There are a number of excellent white papers available on tuning SQL2005 including the...

On the point of the clustered index, I cover this in presentations I do on indexing and there's some mention of this in part 4 of index analysis on my...

I don't want to appear rude but my obvious view is that if you are asking these questions you should be finding a consultant or person(s) who can guide you...

just a point here - generally queries only time out from the client dropping the connection not as an internal SQL Server operation unless it's a deadlock. If you set...

you'll excuse my perverse sense of humour but when you add all those certifications and such to your post and ask what essentially is a really basic SQL question you're...

hmm I did part of my SQL Bits presentation about choice of clustered index - I will be posting this somewhat complex area shortly. It's too lengthy to put in...

I was told on a couple of occasions that changing the threashold actually doesn't make much difference as the optimiser will over-rule your settings if it thinks best - how...

you can do a clean uninstall but it's tricky ( uninstalled 2005 to install 2008 ) What tends to happen is that when you go to re-install it puts in...