Viewing 15 posts - 151 through 165 (of 458 total)
Michael Meierruth (9/28/2012)
rmechaber (9/28/2012)
Did you see my post on page 3 of the comments?Rich
Yes, it's 200 lines of code and comments (I like those!)
But I'm comparing 1 line of my...
September 28, 2012 at 12:20 pm
Did you see my post on page 3 of the comments?
Rich
September 28, 2012 at 11:48 am
Gazareth (9/24/2012)
Is there actually an easy way to check the output from DBCC CHECKDB?
I currently scan the SQL log using xp_readerrorlog for the DBCC output...
September 26, 2012 at 10:01 am
I have several databases that contain scratch data that either don't ever need backing up or only need the occasional full backup, without the usual differential and log backups. ...
September 26, 2012 at 6:40 am
4.Avoid the use of dynamic SQL where possible
5.Use sp_executesql instead EXEC('string') whenever writing dynamic SQL
Color me paranoid: I would change these to "Data access will be performed exclusively using parameterized...
September 22, 2012 at 3:21 pm
Steve Jones - SSC Editor (9/21/2012)
The question has been corrected and points awarded back as of a...
September 21, 2012 at 9:03 am
Stephen_W_Dodd (9/21/2012)
Apparently, not everyone thinks that sp_who2 is total disk I/O (reads and writes).
I think that is incorrect.
As vk-kirov posted, sp_who2 returns data from the system view sysprocesses; the column...
September 21, 2012 at 6:39 am
rVadim (9/20/2012)
I answered "Non of the above". I thought DiskIO in sp_Who2 means reads and writes combined, not just reads as question asks. Am I wrong?
Me, too. <>...
September 21, 2012 at 5:49 am
Ug. Thank you for testing, Lowell, and thank you for confirming my unhappy expectations, Barry. I do see that your SP work-around might work, but there's a lot...
August 29, 2012 at 12:32 pm
Kyle Neier , (8/24/2012)
August 25, 2012 at 7:12 am
Jonathan, though you wrote this 3 years ago, thank you VERY much for a clear, well-written, practical article that fixed a very thorny problem for me: allow users to execute...
August 24, 2012 at 8:49 am
Jeff Moden (8/23/2012)
August 24, 2012 at 8:17 am
Jason- (8/23/2012)
rmechaber (8/23/2012)
That code errors out on my trial:
Msg 536, Level 16, State 5, Line 1Invalid length parameter passed to the SUBSTRING function.
Rich
I've seen this before. There is a...
August 23, 2012 at 12:00 pm
SQL-Tucker (8/23/2012)
I particularly like that it handles variable length run_duration values.
Is there a performance gain...
August 23, 2012 at 10:10 am
I confess this bit me hard in the #$% a while ago, twice: once when I found out that date and time were stored as an INT representation, once again...
August 23, 2012 at 6:18 am
Viewing 15 posts - 151 through 165 (of 458 total)