[font="Verdana"]Er... stop truncating the table?[/font]

[font="Verdana"]Sometimes a little hand holding can go a long way. Like pointing people to Books Online. "Wait, there's a 'books online'? Who knew!" We take a...

[font="Verdana"]Maaaaybe. The XML options differ from version to version of SQL Server, and if your file is a plain text file, getting the XML wrapper to somehow wrap around...

[font="Verdana"]Potato Launchers? Have we graduated from Pork Chops?[/font]

Sankey (3/3/2009)

---

This year, we're planning on creating a data warehouse and implementing an OLAP solution. I've read a little about having a dimensional model or a relational model for...

[font="Verdana"]Either of the approaches I outlined should still work.

Already posted answer

[/font]

GilaMonster (3/5/2009)

---

There is...

[font="Verdana"]Heh. Pushing the limits of my own understanding here!

I believe a join would be merging a list of distinct values, not a range of values. So I'd expect...

GilaMonster (3/5/2009)

---

They can be very good candidates for clusters, especially a...

[font="Verdana"]Er... really? ...

[font="Verdana"]Okay, going from memory here. You can check Books Online for a fuller discussion, and someone please correct me if I'm wrong.

My understanding is that clustered indexes need to...

[font="Verdana"]The way I would do this is to keep the counter in a separate table, and use an identity field on that table as the counter.

However, if you combine your...

Marios Philippopoulos (3/5/2009)

---

Bruce W Cassidy (3/5/2009)

---

[font="Verdana"]One of the tricks of clustered indexes is that they define the physical allocation of the table data. So your clustered index should be...

[font="Verdana"]One of the tricks of clustered indexes is that they define the physical allocation of the table data. So your clustered index should be the best way you want...

[font="Verdana"]SQL Server Express is a very limited edition of SQL Server, primarily intended as a back-end for MS Access and for small web sites and the like. It's not...