Christopher Ford (2/19/2008)

---

I would recommend Microsoft Press Inside Microsoft SQL Server 2005 T-SQL Querying.

ISBN: 0735623139

That will help you tremendously in getting up to speed on SQL 2005 as well as...

I don't have anything specifically on SAN or clustered environments, but here are some links to get you started. I have found them, especially the 1st one, to be very...

By no means the only way, but I tend to focus on the reads...

fred (2/18/2008)

---

I have installed SQL Server Integration Services on my WinXP client but there is no way I can see to launch it, it is not in my start menu,...

Sweet! Thanks for the info and link, that's great!

I would put the UDFs in the model database, then create a SYNONYM in each of the user databases ("dbname" is the name of such a database in the following...

Matt, I completely agree with most of your points, but are you sure about the last one?

An update of a VARCHAR column in a table...

If a row is in a page, and its varchar column is updated from holding 20 characters to 5000 characters, then it's going to cause a page split if...

You also may want to consider making your primary key ID column non-clustered and define your clustered index on a more suitable column, eg. a record timestamp.

Queries involving a *range*...

To retrospectively figure it out, as I wrote earlier:

To get a feel on whether a 90% fill factor is adequate for your index, you can monitor

sys.dm_db_index_physical_stats.avg_page_space_used_in_percent over a period...

shipleyv (2/18/2008)

---

Yes, the primary key is non-clustered. It sounds like if I 1) make this a clustered key, and 2) issue my select WITH UPDATE, that since I only pull...

I know little about this topic, but isn't Notification Services canned in SQL Server 2008?

If so, you might have a problem if and when you decide to upgrade to a...

Also, you may want to consider

Inside Microsoft® SQL Server™ 2005: The Storage Engine

by

Kalen Delaney (Solid Quality Learning)

(http://www.microsoft.com/MSPress/books/7436.aspx)

As Jeff mentions, start from here:

http://msdn2.microsoft.com/en-us/library/ms130214.aspx

If the example you quote here is...