Grant Fritchey (5/11/2010)

---

Whether the DBA knows it or not, that data can get changed by circumstances. It's best that you know that fact in order to gauge best whether or...

GilaMonster (5/11/2010)

---

...

As for the index usage, it's flushed when the DB is closed. Shutdown, restore, detach, offline. There's no way I know of to manually flush it. Eric, you said...

The sys.dm_db_index_usage_stats view exposes statistics about the usage of indexes. I don't know for certain, but I suspect this is part of what the DTA uses behind the scenes to...

You never stated what the error message is or what about the large file doesn't work.

I'm just thinking that when dealing with 1 GB sizes XML files, if you...

field1 will be set to whatever (field1 + field2 + field3 - field4) equals when the UPDATE statement initially starts.

... I only want to see rows 1, 2 & 3...

Dobermann (5/11/2010)

---

I just don't get it. This is what I am trying to do, yet it will not let me add the Gender column because it is not included...

eric_russell 13013 (5/10/2010)

---

I believe that referential integrity constraints are important in a database. If you have data models for two or three tightly integrated applications with overlapping foreign keys and...

Let's assume that there are several (or a hundred) tables which partition client data, and they are all prefixed with the name 'client_data_%', and you need to create on each...

A long time ago, I was asked to write some custom reporting SQL queries against a 3rd party database containing 100+ tables. It had one unique key on most tables,...

I believe that referential integrity constraints are important in a database. If you have data models for two or three tightly integrated applications with overlapping foreign keys and sharing of...

Linking Servers:

http://msdn.microsoft.com/en-us/library/ms188279.aspx

Once you have created a linked server object for the remote server, there are several options for returning a resulset and joining it with local tables....

PaulB-TheOneAndOnly (5/7/2010)

---

Can the original developer...

I think we need a new podcast series on MSDN or somewhere, and base it on the TV series 'Trading Spaces'. It could be called perhaps 'Trading Schemas'. Two developers...

Since ClientID is not unqiue, then I assume the purpose of this ClientNum is to create a composite primary key. You can persist a calculated column using the PERSISTED clause,...