Well...

After seeing so many suggestions here about improving querries, let me try to Sum up the Articele in one sentence...

DONT put a field of a table into ANY function. This...

Good Article...

I often see querries who do this wrong... Especially the "Date-30" querries.

Hello...

I have to agree with most former posters! Bitmasking is NOT the way to go... I can see the "posibility" to store "ONE" flagged enumerations inside a single field(This is...

There are also several FREE eLearning sessions for SQL 2005 from Microsoft. But I must admit I didnt find them very enlightning. "Playing" with the server and watching some webcasts...

Hello...

You might take a look at the so called "SmartDate" Datatype. This Datatype is NOT is default .NEt Datatype, but it is included with CSLA.Net from Rocky Lhotka. Its a...

I was thinking a bit about the performance problem I mentioned above when creating a sequence.

The group by querry could be rewritten so it can correctly use the indexec.

The following...

It should be a separate column and concatenated into the computed column that is displayed to the user.

I think thats the most important post in this discussion. I think one...

Wellll...

If they dont show up in Visio (Or inside SQL when you add a table to the diagram) then yo are missing one thin

The relationship itself. Be prepared for a...

Hi...

I usually clean up my "mess" with "something" like this

delete from myTable where myID NOT in

(select min(MyID) from myTable group by myUniqueField)

But I think the best application for CTE...

Hello...

I had the 441 on Monday also. I must say i also was plesantly supprised about it. The questions really only made "sense in the context" of the business case....