sql 2008 can compress data and backups

we're looking to buy a few server with the new 6 core CPU's. the worlk load is going to be different on these with over 2000 connections at a time,...

it's a single quad core CPU in there now. the server is experiencing mission creep and i've been thinking about requesting another cpu

if i play with the cost threshold, should i set the max degree of parallelism to 4 or 8 instead of the 1 that i tested with?

DPS is the right order

starting with SP2, the install has been very nice. it even updates both cluster nodes with one install. we did have an issue one time where...

most likely a DNS issue. is your internal AD DNS zone totally separated from the outside world and not published?

i've had the same problems and i either RDP to an...

how long would it take to rebuild one index?

this may be a business case to request new hardware or look at your I/O system. i've tested stuff like index rebuilds...

see it now

only has a modified date though. a DDL trigger will have the actual SQL of the change. we have it in the tickets opened for the changes, but...

which tables would i look into to track changes to user tables?

Lynn Pettis (4/28/2010)

---

Brandie Tarvin (4/27/2010)

---

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets...

in the database properties, do you have any free space in there or is it almost full? what about when you right click on a database, go to reports and...

i think you have to run alter index rebuild in order to reclaim used space. it will compact the indexes. haven't run the lite version of alter index for a...

http://www.sqlservercentral.com/articles/Backup/66564/

used this as a base, but made a lot of modifications and wrote a lot of my own reports. was going to submit it as an article but haven't had...

i set up a system where i run SSIS packages to grab the data from msdb and then i have some SSRS reports emailed to me daily. it's based on...

if the disk has multiple database files on it then it's best not to use shrinkdb. reason is that if it grows and you shrink it then the file will...