crainlee2 (9/17/2009)

---

Thanks Grant and Ten. I'll simply move forward on indexing.

Old Hand: Note that without a WHERE clause, a CROSS JOIN produces a cartesian product. If you don't believe me,...

Indexes on some types of columns in highly transactional tables can often fragment very quickly.

There are a few possible solutions, depending on how the indexes are being used, and what...

What you do is add error handling to the procs that are doing the inserts, updates, and deletes in your database.

If you have a Try Catch structure in an insert...

The only way I can think of to automate what you're doing is to create a DDL log, probably using DDL triggers, and then use dynamic SQL and some string...

I got into database work from a sales position, with a light background in macro coding for WordPerfect.

The thing that made it possible for me to get the basic ideas...

If you're looking for natural PKs (which is what it seems you are doing), the definition will depend entirely on the nature of the data itself.

Are there columns that the...

On a matter of principle, I don't support illegal software. I'd be doing that indirectly if I go any further on this. I have too much respect for...

What do you then plan to do with the variable? Does it go into the Where clause of a select statement?

If so, why not just use the start and...

Only you can judge the cost/benefits/risk ratio on this one, since it's going to be subjective.

Would it possible for you to bring your concerns to a higher manager or executive...

What I always recommend on pivot/unpivot questions is, use a better tool than T-SQL for it. Excel, Reporting Services, Crystal Reports, can all do pivot/unpivot better than SQL Server...

He doesn't have a licensed copy of Windows?

I recommend convincing him to shift to a free OS (FreeBSD is my favorite in that category, but lots of others like Ubuntu...

In SQL, dates are considered midnight if they don't have a time assigned to them. Thus, what you're looking for are rows that are in between midnight on the...

Run this in your query tool:

select *

from master.sys.sysaltfiles

where name = 'MyDB';

Try that, see what it finds.

You're trying to assign all of the dates between those? You can't assign multiple values to a single variable.

What is this part of? What will you use those...

It sounds to me like staying will be convenient, but will probably result in stress-related health and personal issues.

How important is staying to you? Is it worth spending the...