Viewing 11 posts - 466 through 476 (of 476 total)
RE: Term_Date = 20790606 or 99991231.
Just because we (presumably) won't be around on either of those dates doesn't mean they're safe to use. Somebody may be. Come that date, I...
October 24, 2003 at 1:45 pm
BCC,
This looks like the output from the startup of the SQL Server (you should see the last line in the SQL Server error log, as well -- one line for...
October 24, 2003 at 1:26 pm
Hi Dave,
OK, that's all good.
Question 1) Can you tell who (which user) is connected to the server when they get there via the app?
Question 2) If the app can connect...
October 24, 2003 at 12:55 pm
Thanks for the replies.
No, no temp tables used.
Steve, I will try to set the alert, however, these deadlocks only occur under very high load, which typically only happens once or...
October 23, 2003 at 6:35 am
Hi all,
Thanks for the input.
Application roles: Don't want to do this, we are aiming for *really* thin clients, all business rules (including security) on back-end. Also, from what I have...
October 23, 2003 at 6:29 am
Sounds like a subquery...
Something like
SELECT <some fields>
FROM <some tables> as st1
JOIN (SELECT <some fields>
FROM <some other tables>) AS st2 ON st2.<field> = st1.<field>
Now,...
October 20, 2003 at 9:36 am
Sounds like a subquery...
Something like
SELECT <some fields>
FROM <some tables> as st1
JOIN (SELECT <some fields>
FROM <some other tables>) AS st2 ON st2.<field> = st1.<field>
Now,...
October 20, 2003 at 9:36 am
5409045121009 and whoteegan:
Thank you for the replies.
Raiserror in sproc #3 is handled correctly. No results are returned to the application, and the error message is displayed where expected.
whoteegan: Application not...
October 6, 2003 at 5:53 am
Sounds like a index problem, as in lack of useful indices. You don't mention any in your post.
Also, I'm not sure, but it appears that ExclusionList might not be normalized....
August 6, 2003 at 7:08 am
Not enough information to make a meaningful diagnosis: How do you know your query should execute faster? A 'simple' select statement on a 50-million row table with no indexes could...
August 6, 2003 at 6:45 am
Viewing 11 posts - 466 through 476 (of 476 total)