I've always used Shift-Alt for this, never realised using just Alt does the trick as well!!!!

If indeed it is an errorlog and not a tlog file you are trying to open then I'm old skool and still love PFE32 for large files

I can imagine there'll be a few comments on this topic regarding why you shouldn't use maintenance plans, I'll make a start:

You may redesign indexes by specifying a new fill...

This has also worked for me. - granted it was for SP1 CU4

On reviewing the previous logs I could see that a patch done almost 1 year previous had been...

Hi Kevin,

thanks for the reply. I did indeed find the stuff isaac has done and played around with it a bit last night and currently i've got the spatial query...

thanks Grant, i'll take a look at the links! 😀

thanks

i wrote a blog on a similar issue here...[/url]

My example is using ISNULL but works in similar way. Massive performance gains to be had!!

Your statement is incorrect - if you have a reference that says otherwise please provide it.

In this particular case a table variable will likely be best, because you...

best thing would be to invest in something like sqlsentry to monitor your system.

If you don't have the budget then running a server-side trace and possibly collect some perfmon counters...

jay.dunk (3/6/2012)

---

I do something similar on a 24/7 db, 365 days a year with all files on a single raid 5 partition!?! I use the same approach but with a...

not sure if this is the best way but i'd look to trace the user(s) and at the end of each day import the trace file into a table and...

Are you using SQL 2008 compressed backups? Also, can...

are the log backup jobs for all databases running concurrently or sequentially?

has it always done this or has it just started happening? If recent, anything in the application/system log around...

Have you actually read any of the responses that have been given so far??

be careful with the fillfactor as you can affect read performance if you don't get it right as there will be more pages required to be read into memory for...