sonal_anjaria (10/21/2009)

---

I have been trying to find out how to view the "logs" when data file's grow, what tool did the person asking the question use to see the data...

ed_elfrink (10/20/2009)

---

TheSQLGuru -How about some examples of these "amazingly bad things" you say the tuning advisor has done to databases? I've used it a couple of times with great...

Search this forum (and...

There are several examples of the 'tsql variable trick' already posted. 🙂

sauraviit, did you actually read the posts before you before making your post?? :w00t:

Job histories and backup/restore histories are the things that take the most room over time in msdb. They can both be pruned using system stored procedures or maintenance plans.

Buy a server with 256GB of RAM and 16+cores of CPUs and your table scans should run quite quickly since you won't have to touch the disk at all! ...

You cannot explicitly configure the procedure cache. If you are on SP2+ then you have lower ratios of procedure cache than prior to that version, which actually could be...

There are probably a dozen or more things you need to investigate and rule out before doing something like hinting maxdop. You should consider getting a professional tuner to...

For me it was Hunt the Wumpus, hand-coded on my TRS-80 Model III circa 1979. I think there was another one I did, something that started with a 'Z'...

The key thing to be learned here is that optimal varies GREATLY depending on the situation! Having many tricks up your sleeve for solving tsql problems (especially the common...

Jeff, try your sample code without your beloved clustered PK. That eager index spool eats you alive. 74.5 cost and 2.6M IOs. The real world rarely has...

Boy, the video game chatter has me realizing how long in the tooth I am getting as well! sigh...:cool:

Is there a way on this forum to increase the number of posts shown per page?

No I do not - I just assumed there was a...