I am back from London!! PASS is at the end of september. Now

WHAT inthe world  rgR'us  means??

hehe...  I got in a bit late 

To specify that the string is in unicode format ie. nvarchar or nchar

Cheers,

I would like to add a bit more of clarity to what I said before:

The minute you declare a Column data type you are using BUSSINESS RULES

The minute you use...

You need to implement an INSTEAD OF trigger to handle those fields. They (text, image, ntext fields) are available for that kind of trigger!!

Cheers!

You need to implement an INSTEAD OF trigger to handle those fields. They (text, image, ntext fields) are available for that kind of trigger!!

Cheers!

If you've been to a Databases 101 course with a minimally decent teacher the FIRST thing you learn is GARBAGE IN- GARBAGE OUT. You must(is your responsability to) ensure your...

Lesson #7: Find the CAUSE first!

We have a dba  .... - he's a bit difficult

One of the expected characteristics of a good DBA! Not saying that if you are not difficult you may not be...

you are using -E on osql that would mean that you will need either to setup  ACCOUNT DELEGATION in kerberos OR change the connection to use SQL authentication( -U...

if you have the nested triggers flag enabled make sure it is really needed otherwise turn it off

If you are calling a recursive stored procedure or a recursive function in...

I am not an specialist in Reporting services but I believe you are approaching the problem the wrong way. You should be able to perform a simple select returning a list of...

Oh and one more thing

When you said: I can INSERT/SELECT 15 million rows in minutes ...

I hope you meant :  I can SELECT INTO ....

The amount of logging on...

Not sure again I am guessing govinn meant to put those expressions as the predicate of the where clause!

SELECT * FROM TABLE WHERE

CASE WHEN (DATEPART(DAY,GETDATE()) < 8 AND DATENAME(WEEKDAY,GETDATE())...

Yes, you have to make sure you get all permissions, triggers, indexes, keys, and so on, but that is why I use EM to create the original script.

And the...