Viewing 15 posts - 41,731 through 41,745 (of 49,552 total)
Bob Hovious (1/14/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 1:15 pm
I believe it is required in the latest SQL standard. (correct me if I'm wrong, I haven't actually read the standards docs)
One of the reasons that it will be required...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 1:13 pm
Joseph (1/14/2009)
What if I run some kind of audit that requires the snapshot to represent a specific date and time?
Don't let the disk run out of space. In addition, make...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 1:05 pm
Just don't call that directly from within a trigger. I detailed all the reasons earlier in this thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 1:02 pm
Sandra Skaar (1/14/2009)
Total Drives (C, E, and F):Disk Writes/Sec: 10.74
Disk Reads/Sec: .067
Not so interested in the reads/sec. What does the avg sec/read and avg sec/write look like?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 12:53 pm
foxjazz (1/14/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 9:39 am
Why the cursor?
DELETE FROM Logins
WHERE UserID IN (SELECT USER_ID
FROM...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 9:00 am
Why a double \\ in the file name?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 14, 2009 at 8:22 am
Viewing 15 posts - 41,731 through 41,745 (of 49,552 total)