If you do use Unicode, all Unicode is not the same. The Win32 API, Java, ODBC/OLEDB, etc all use UCS-2/UTF-16 as their

representation of Unicode (UCS-2 encodes Unicode using...

At a technical level, the datetime field is two separate integers. The first is the number of days starting from the data Jan 1, 1900. The second integer part...

I suggest that you verify that the DELETE where clause is doing what you think. When ever I use QA to directly manipulate production data I always first verify...

Personally, I'd recommend everyone to focus more on the business side. From a compensation standpoint, it is a lot higher ($100US to $200US annual)

It's great to know all the...

Really need to grind up this horse....

Greg is correct, UPDATE is not a real option, but how should we know the intent was to say UPDLOCK. Hey, today, John started...

quote:

---

update trigger that when fired, updates the very same record that caused the trigger to fire. This was not allowed in SQL7....

I agree with viacoboni.

The first choice would be to change the HOLDLOCK to and UPDLOCK.

Not to remove the lock completely.

Or rewrite the proc.

OK, you got me on the bulk-logged QOD. B)

But, it is a great question. I run all systems using full, and I suspect that like most DBA's, have...

Since you have two issues here, first split them up. As mentioned, use DATEADD to add or subtract days to get the desired date.

DECLARE @myDate varchar(20), @dtDate datetime

set @dtDate...

Some good stuff here.

Sounds like you already use triggers to capture who deletes, so, as mentioned above may want to add to the trigger to capture the deleted data.

You...

Looks like a good, common sense approach. Hope I never have to use it!

I've been fortunate to only have met a few oracle types, and regretfully, they have lived up (or is it down) to the oracle reputation.

Personally, I don't see the oracle...

We have one old application that uses SQLBase. The guy who wrote it (Gupta) use to work at Oracle, so if you love Oracle, then you would probably like...

SQLServer has Sunday as day 1 of the week, so if you want your week to start on Monday, it can be a pain.

I had a similar problem a few...

For production system, I agree, just say no. Manage space usage based on the business needs (slow time) and don't rely on Auto Shrink.

I've found some "production" systems such...