Viewing 15 posts - 41,746 through 41,760 (of 49,562 total)
foxjazz (1/14/2009)
January 14, 2009 at 12:50 pm
foxjazz (1/14/2009)
I have triggers that call a stored procedure that sends a message using service broker.
Ok, I'm confused. You didn't mention anything about service broker before.
Wouldn't it be possible to...
January 14, 2009 at 9:43 am
foxjazz (1/14/2009)
It's too bad however I can't use it to send a udp message to listening clients.
Why not? Have the service broker queue's activation procedure be a CLR procedure. It...
January 14, 2009 at 9:39 am
Why the cursor?
DELETE FROM Logins
WHERE UserID IN (SELECT USER_ID
FROM...
January 14, 2009 at 9:30 am
In the future, if you post pieces from the error log, please find and open the error log in a text editor. The log reader within management studio puts the...
January 14, 2009 at 9:26 am
Ok, let's see....
4 processes involved in the deadlock,
Process 1 - Spid 174, running the select on line 136 of the procedure with ID 2099048 in database 20. It wants a...
January 14, 2009 at 9:13 am
foxjazz (1/14/2009)
Ok, instead of giving me problems, how about providing a solution.
This is not the first time that you've criticised the free help that you're getting here. If you want...
January 14, 2009 at 9:09 am
Grant Fritchey (1/14/2009)
Evidently I'm only providing problems, not solutions.
*twitch* I'm losing my temper here....
January 14, 2009 at 9:06 am
plreeter (1/13/2009)
Does anyone know if disabling the indexes and rebuilding them after the bulk insert is a more efficient method than dropping the indexes and recreating them after the insert?
It'll...
January 14, 2009 at 9:00 am
Since you have the execution plan that you want to force, try using the OPTIOn (USE PLAN ...) hint. That guarantees that the baseline query will never change plan.
The disclaimer...
January 14, 2009 at 8:21 am
A snapshot is a sparse file. The size of the file appears to be the size of the database, but it hasn't reserved that much space on the disk. The...
January 14, 2009 at 8:07 am
If you're on SQL 2005, and I assume you are because this is the SQL 2005 forum, use traceflag 1222 rather than 1204. It produces a lot more output and...
January 14, 2009 at 8:04 am
For testing purposes only!
Hints should not be used in production code, unless you really, really know what you're doing and are 120% certain you know better than the optimiser.
Right, now...
January 14, 2009 at 8:01 am
Viewing 15 posts - 41,746 through 41,760 (of 49,562 total)