Interesting concept. I'd probably use a date table only because I would need to expose the data in an SSAS cube and I already have a date dimension table...

WayneS (4/28/2010)

---

You do...

Someone asked about 64-bit...

Linked servers from SQL Server still won't work if SQL is 64-bit as you're trying to have it use 32-bit OLEDB/ODBC drivers. There's no thunking like...

Garadin (3/29/2010)

---

Ian Yates (12/9/2005)

---

3ms is the smallest unit of time a datetime field can capture. So by subtracting 3ms from midnight, you get the latest possible time that could be...

Hmmm, I haven't had the time to post on here for months (this thread's had some activity again?). I used to write a lot of my posts fairly late...

No problem

Leon, I think you misunderstood. Please try it - if you drag "Columns", not an individual field itself, then you'll get them all transferred. Each is separated by...

Great article, except that you (and the other posters) either don't use Query Analyzer or SSMS to write your queries, or you do and aren't aware of a neat trick...

In...

Browse there manually using Windows Explorer and then cut&paste the path and backup name into the bottom text field of the dialog box that's showing you your folders. You...

What problems are you experiencing that are making you look elsewhere?

I think that was the longest and most comprehensive reply I've ever seen on here Shame it wasn't used Hopefully when someone else asks the same...

The suggestion from another person about using indexed views for the purpose is probably the best. It's a separate copy of the data (with extras thrown in if needed)...

Yes it will do the update, but in case you're trying to update the row with row #1 value A from the 2nd table and then row #5 value B...

Hi,

You can use joins in update queries much like you could in a select. This should solve your issue. Also, please post using the (code) forum formatting shortcuts...

You should read up on exactly what a clustered index is rather than a regular non-clustered index and the difference will make it obvious.

Essentially a clustered index defines the physical...