i kid i kid

but for us mortal people who don't work for consulting companies and who's employers don't pay for this stuff it's out of...

are they free?

Question Guy (1/7/2011)

---

Very good info.

As a side note, the biggest problem I have had with index/query slowdowns is with extent fragmenation. While I've read that extent frag...

works fine on my 3GS

i wasn't much into FPS's until i played Call of Duty Black Ops in the last month

never had a problem with AV software. i use Symantec Endpoint Protection i get from work.

after much thinking i'll probably buy a laptop next year along with an iPad and...

in my experience it's a lot less painful than spending 3 hours with the string functions getting the email just right. i can't even remember most of the string functions...

if you have the same indexes on the subscribers as the publisher, start running the index DMV's to check for unused indexes and delete them. it will reduce your I/O...

is this a select query? why not just use SSRS?

dajonx (12/22/2010)

---

Hi,

I was wondering if anyone has any resolution to this problem that I'm having. I currently have 64-bit SQL Server 2005 SP2 on my backup server and I...

i think it's part of SQL 2005 and later, but you can run it during a backup. i use Netbackup and my scripts are set up to check for consistency...

have you checked for missing indexes?

i dump my physical_stats index DMV to a table and run the missing index DMV's once a day and then create a report with the...

installed it in QA yesterday after i upgraded one of their servers to Windows 2008 R2 from 2003. they were on a build in the 4000's so i just installed...

when my kids get older i'll be contributing a lot more

they will probably have higher capacity hard drives by then that you can replace into your existing RAID5

just make sure you're running Windows 2008 R2