1) I didn't notice anyone else asking what else is running on the server. If this is not a dedicated SQL Server box beware using /3GB.

2) If...

If you are going with the configurations listed, I would pick 1 or 2, but use only 2 drives for the OS and throw the other 2 72GB in with...

GSquared (8/26/2009)

---

That's certainly one way to do it.

I'd take a look at the documentation programs available from RedGate and ApexSQL. Might be more useful/efficient at it. Those are...

San (8/26/2009)

---

Hi,

Thanks for your replies.

But am not asking abt DB Diagram. Infact am pretty familar with that. Am talking abt Data Dictionary only. At present it's somthng like this.

1st sheet...

I wonder if there isn't a way to 'force' or 'convince' SQL Server that the computation IS deterministic which would allow it to be persisted...

I don't know if they still have the program, but 3-4 years ago I purchased ERStudio, DBArtisan and ChangeManager with SQL Server-only licensing limited to 5 or 10 (can't remember)...

I call them Entity Relationship Diagrams, and I use ERStudio to do the work. You can use Visio and even the built-in SSMS Database Diagram feature. There are...

RBarryYoung (8/24/2009)

---

Actually, this not true. Even without FK's there are techniques to discern the...

GilaMonster (8/21/2009)

---

TheSQLGuru (8/21/2009)

---

If you join to a table on 1 (or a few) values and you hit 90% of the rows in the join table do you really want to...

Grant Fritchey (8/21/2009)

---

TheSQLGuru (8/21/2009)

---

Just to make clear, it isn't JUST about the number of rows you put into a table variable/temp table that matters. I can also be the...

Grant Fritchey (10/29/2007)

---

Everyone else has covered this for the most part, but I don't mind adding one bit of information. Table variables, unlike temporary tables, do not have statistics created...

Seems to me that if you did native backups in parallel (2 streams) and hyperbac sequentially and they took the same time to complete then hyperbac is twice as fast....

A) yes, shrinking database causes severe fragmentation

B) Not an SSIS guru - others can advise on best mechanism for doing incremental loads

C) Since you have issues with tlog growth and...

It continually amazes me how often in the SQL Server world that a complete newbie gets thrown into the deep end of the pool and made responsible for mission-critical stuff....

Rowan (8/19/2009)

---

Thanks, I will visit this option, but because I'm drawing data from a DB2 database I will have to see how this can be done.

Just to give you an...