The nice thing about a SQL Server stored proc is that it doesn't bomb off when this type of failure occurs. You can check the @@ERROR value, if it's...

Splitting your data base into multiple data bases is usually driven by security reasons. If you have tables that are shared, splitting them into multiple data bases will only...

This is a common task that many people face and it's too bad there's not better support for it from Mi¢ro$oft. What we typically do is this: create...

From 1st hand: we took the create a linked server and query over approach. Oracle has a nice provider and the transfer was almost seamless. using alinked server,...

It comes down to a company by company basis. In my experience, studying for certifications (MCSE, MCSD and MCDBA) has taught me things I didn't know and helped me...

There is always a way to avoid storing external files in a data base table. I would avoid doing this at all costs.

If you insist, use a varbinary field...

You need to be aware that having multiple statements that are executed differently based on conditional logic generates the cached execution plan based on the 1st call to the proc....

Like most everything, it depends. We use table valued user-defined functions instead of views for a lot of things. This makes for better performance in almost every case...

We recently did the same thing but took a slightly unusual approach. We created a table valued user-defined function that basically did the select distinct() function portion, then joined...

quote:

---

I'm trying to teach myself how to write triggers. I understand the basics, but my boss wants me to figure out...

quote:

---

Does anyone have a script that will tell you how a column is used in an application?

---

December 3, 2002 at 7:41 pm