Viewing 15 posts - 31 through 45 (of 95 total)
Patrick,
If you save a phone number as a varchar, it will be at least 10 bytes per item. The BigInt is only 8 - a BIG savings with many...
November 4, 2003 at 11:06 am
Whoops-
Not working at all.
If I have one number 1234567890 in the table as a real and do a SELECT WHERE X = 1234567890, it returns the one row - fine.
But,...
November 4, 2003 at 9:14 am
Well...
I'm going old school and re-formatting my DEV machine. Full reinstall from scratch.
My registry is saying "ahhhhhh - thanks".
October 7, 2003 at 8:04 am
Brian-
The MSSQLServer service is logging in using my account.
babuganesh2000-
There is a local SQLDebugger user on my machine - but not a group to which I can add myself.
Plus - I...
October 7, 2003 at 7:06 am
Heh-
Thanks Dave.
What got me started with the QA debugger is that I could not get the VS.Net IDE debugger to work with T-SQL statements.
Me have total no worky w/ T-SQL...
October 6, 2003 at 10:35 am
A few things...
1) After much tinkering - I got this nasty bugger down to 2 seconds !!! Wheeeeee.
2) I'm not running it in QA - we have no such thing...
September 17, 2003 at 2:00 pm
Thanks Steve,
But to continue whining ... 🙂
In general, the server runs most everything twice as fast as my local PC. This is the first time I've noticed such behaviour....
September 17, 2003 at 10:50 am
Frank-
Checking the MIN date is exactly what I'm doing now. The problem is/was, in our "Model Analysis", the Model includes typically 5 Funds - so I have to check...
September 15, 2003 at 7:59 am
Frank-
I've spoken w/ you before in this forum I think...
Yes, I'm running performance numbers on financial returns. We have our own Mutual Funds here and are keeping track of...
September 15, 2003 at 7:48 am
Thanks all...
I was hoping for perhaps a simple "SET Statement" solution, like:
< SET NULL_AGGREGATIONS ON >
or something like that...
FYI,
I have several series of data.
Each series has data every day, but,...
September 15, 2003 at 7:22 am
Thanks but no go.
I do NOT wan a value back - I want NULL as the total result.
I did however try this:
SELECT SUM(ISNULL(VAL, NULL)) FROM
(
SELECT 1 AS Val
union
SELECT 2
union
SELECT 3
union
SELECT...
September 12, 2003 at 2:02 pm
List of problems with xp_Sendmail:
http://search.microsoft.com/search/results.aspx?View=en-us&p=1&s=0&c=3&st=a&qu=xp_sendmail&na=30
My problem with a query and xp_Sendmail:
http://support.microsoft.com/default.aspx?scid=kb;en-us;164998
A Summary...
"Another limitation of SQLMail is that if xp_sendmail is called with the optional @query parameter,...
September 9, 2003 at 8:22 am
Thomas-
Did the StopMail and it said that the sever was not started so it could not be stopped. Then did Startmail and it said it was able to start....
September 9, 2003 at 8:16 am
Thanks Tommy ;)-
Will give it a try and see what happens.
Just wanted to make sure that StopMail has no far-reaching nasty side-effects(affects?).
It's just odd to me that the "Operator Test"...
September 9, 2003 at 8:02 am
Thanks Tom-
I usually avoid XP_SendMail because it locks things when using a query as part of the output. Before I try the Stop/Stop Mail commands - what do they...
September 9, 2003 at 7:39 am
Viewing 15 posts - 31 through 45 (of 95 total)