Viewing 15 posts - 1 through 15 (of 195 total)
I got 3.33 ms on a 32bit OS: WIN XP SP3 / SQL Server 2008 SP1 on dual core machine (Intel T2500).
May 12, 2010 at 7:24 am
WIN XP SP3 / SQL Server 2008 SP1 on dual core machine
getdate: 6043 3.3399 & 5957 3.33557
sysdatetime: 1713 15625 & 1789 15625
May 12, 2010 at 2:35 am
What is the function of your database: OLTP or data warehouse?
March 5, 2010 at 12:04 am
You could use an indirect configuration through an environment variable.
March 1, 2010 at 12:01 pm
Paul White (2/27/2010)
wschampheleer (2/27/2010)
Easier to write and maintain.
Seriously? That hasn't really been my experience. CASE statements are a great way to avoid using a useful index, of course...
February 28, 2010 at 12:35 am
Paul White (2/27/2010)
wschampheleer (2/23/2010)
February 27, 2010 at 12:22 pm
keywestfl9 (2/25/2010)
i am passing...
February 26, 2010 at 1:18 pm
Try to create a simple package where you only copy the file (or disable the Execute Package Task). This will already allow you to eliminate some possibilities or point you...
February 26, 2010 at 1:16 pm
Griffster (2/26/2010)
February 26, 2010 at 1:13 pm
I gues your problem is data overflow. What do the formulas in your derived columns look like?
February 25, 2010 at 10:34 am
ragie (2/15/2010)
February 25, 2010 at 4:44 am
M_GREAT_4_SQL (1/12/2010)
Thanks Dear, but is there any other way through that we can get error message.Thanks,
I have been using a technique loosely based on this article for several years...
February 25, 2010 at 4:33 am
Elliott W (2/24/2010)
Why don't you try:[column1] =="1/1/1900" ? [column1] : NULL(DT_DBTIMESTAMP)
CEWII
You need to reverse the 2nd and 3rd operand.
Also, I assume that col1 is of datatype DT_STR or DT_WSTR, so...
February 25, 2010 at 1:11 am
Didn't know you could do that from within an agent job! Is that a specific step type such as Operating System (Cmd Exec)?
Yep, that's the one. In the command box...
February 25, 2010 at 12:58 am
For the field in question in my data reader > input output properties > external columns, the datatype is already eight byte signed integer (DT_I8). Should I be converting it...
February 25, 2010 at 12:37 am
Viewing 15 posts - 1 through 15 (of 195 total)