Viewing 15 posts - 16 through 30 (of 62 total)
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...
September 25, 2003 at 6:28 am
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...
September 25, 2003 at 6:10 am
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...
September 25, 2003 at 5:58 am
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...
June 19, 2003 at 6:43 am
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...
June 11, 2003 at 12:12 pm
quote:update trigger that when fired, updates the very same record that caused the trigger to fire. This was not allowed in SQL7....
June 10, 2003 at 9:19 am
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.
June 10, 2003 at 7:04 am
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...
June 4, 2003 at 6:51 am
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
May 29, 2003 at 6:17 am
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.
May 27, 2003 at 7:27 am
Looks like a good, common sense approach. Hope I never have to use it!
May 27, 2003 at 7:18 am
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...
May 16, 2003 at 11:38 am
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...
May 16, 2003 at 11:15 am
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...
May 7, 2003 at 7:25 pm
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...
May 6, 2003 at 5:29 am