Also, VARCHAR2 is an Oracle Datatype which in version 7 was limited to 2000 chracters, with 8 went to 4000 and may be higher now. VARCHAR and CHAR in SQL...

Select Into can create locks on the source tables which can block other processes. They have done better in recent times but it has always been better to Create and...

This is my preferred method.

DATEADD(m,DATEDIFF(m,0,GETDATE()),0)

This will give you the first day of this month midnight.

DATEADD(m,-1,DATEADD(m,DATEDIFF(m,0,GETDATE()),0))

This will give you day one of the previous month midnight.

Then do

SELECT .... WHERE DateField >=...

I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL...

Actually is a fun question folks. The problem is actually a bug and should have by all standards thrown an error of some kind. But for some reason the parser...

If you were a good DBA and took regular backups you should be able to recover with a restore of your last master dba backup.

Unfortunately folks it was a trick question and the explination was incorrect.

MIDDLE will work because middle is neither a valid syntax or a keyword of any kind,

What is actually happening...

I purposely just choose LEFT JOIN because MIDDLE doesn't exist and because any of the others could have worked if they had a where clause.

However in testing I caught that...

Try this script it will tell you not only what the users have permissions on but what user defined roles they may be getting it thru.

http://www.sqlservercentral.com/scripts/contributions/268.asp

It doesn't give system...

Tried Redgate, AdeptSQL and ApexSQL. Sure you get a bit with Redgate but overall AdeptSQL had the best performance but don't see much going on with it. However I went...

But again this was only my opinion. Everyone else is entitled to ignore my opinion and you are more than helpfull by posting here your opposition to my opinion. I...

Thanks

From my understanding and to the best I can think of. You cannot do this and there is no way to work around it and still use the UDF.

The only way I know of right off is thru a trace. Using Profiler look at the event unde TSQL "SQLStmt:Starting" and if using SQL 2000 you can filter the...

No ou cannot set thread priority for each item. You may want to rethink your transaction management and let all be handled in SQL 2000, but without a lot more...