I think that T-SQL could use something similar to HTML's #include server side include directive for inserting repetitively used blocks of code like error handling, auditing, or variable declarations.

This MSDN article describes some of the...

shannonjk (5/12/2010)

---

How would you handle best practices as far as database file structure if you merged databases to one and used multiple Schemas? For instance if I put 2 databases...

GilaMonster (5/12/2010)

---

Do not, please, ever do that and run the run the generated script as-is. Or, if you do, let me know so that I can send you a proposal...

satya.sakamuri (5/12/2010)

...

if i run the above script inmy sql query with selecting perticular database ....will the data in tables effect?becaz those are production live tables in that database.

could you plese...

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,...