Thanks to all for the replies

How long have you been following this routine? Apart fromm the fact that you are most likely fragmenting your disk (which in time will...

hmm...beware of these "hydraulic lunches" they can lead to pneumatic afternoons :w00t:

I've posted about this before, but it's relevant to this discussion too...

We have a mirrored database in production which is reindexed once a week - the reindexing causes the log...

Here's a method using T-SQL:

--...

Thanks for replies to date

I already use books online (BOL) as a reference - and I also run some of the T-SQL code provided on this site for practice...

ok - but does the code look ok?

I welcome constructive criticism

scalable, maintainable and robust...not in the original spec!

if that was a contract i'd be looking for additional payment for variations :w00t:

This was meant as a quick coding test...a rough...

Fair enough Jeff...this will scale up to 400,000 (on our system). Further joins would increase that number:

SELECT

CASE

WHEN (i % 3=0 AND i % 5=0) THEN 'FizzBuzz'

WHEN i %...

how about (results in text)...

SELECT

CASE

WHEN (i % 3=0 AND i % 5=0) THEN 'FizzBuzz'

WHEN i % 5=0 THEN 'Buzz'

WHEN i % 3=0 THEN 'Fizz'

ELSE CAST(i as VARCHAR(5))

END...

Re: custom colors for the chart.

I have just done something similar to jeff122877's approach - but to standardise things I created some custom code. In my case it was...

Those little fine tuning screws at the bridge are great - so easy to get a perfect tuning that way (assuming intonation is...

I rescheduled the backup log / shrink log job to run at a different time - and it worked ok this time, so I'll leave it set up like that...

thanks for the info Ol'SureHand - I will try adding a couple of additional log backups to the scheduled job (each in its own job step) and see if that...

just reviving this thread rather than starting another one...

I have a similar problem - a 20GB production database (FULL recovery model) with the log file size typically around 2GB. Once...

great to see this thread come back to life!:w00t:

for all frustrated 120W amp owners out there that can't crank up the volume at home - try a Mesa Boogie Express...