My two cents - All Comments

SQL Server v.Next (Denali) : Why you should start testing early

Aaron Bertrand — Mon, 27 Jun 2011 12:52:57 GMT

Denali is coming, whether you like it or not. You may not be an early adopter and you may not have plans

Reading the Transaction Log

Malathi's Blog — Thu, 16 Dec 2010 07:17:49 GMT

It is fairly known to most long term DBAs that DBCC log and ::fn_dblog function are undocumented commands

re: Getting all the Clustered keys in the database

leo.pasta — Mon, 30 Mar 2009 21:57:50 GMT

Hi Saggi,

Thanks for the feedback, I've updated the script. Indeed your suggestion is more elegant and foolproof.

re: Getting all the Clustered keys in the database

Saggi Neumann — Mon, 30 Mar 2009 18:49:30 GMT

Hey,

Nice script!

You'd probably want to replace the following part of your script:

SUBSTRING( ( SELECT ... FOR XML ... ),2,9999)

with a neater solution:

STUFF ( ( SELECT ... FOR XML ...) ,1,1,'')

which simply replaces the first character (',') with an empty string.

Cheers!

Bookmarks about Fragmentation

Bookmarks about Fragmentation — Tue, 07 Oct 2008 19:30:08 GMT

Pingback from Bookmarks about Fragmentation

Debug Output using RaisError With NoWait

blog.servicesonsql.com — Wed, 24 Sep 2008 02:28:23 GMT

I've seen a few folks out there talk about using RaiseError With NoWait as a way to get output from a script, instead of using something like PRINT GetDate(). This has been a good approach for me as well. One thing that I've noticed is that there aren

Link Listing - May 11, 2008

Christopher Steen — Mon, 12 May 2008 07:41:14 GMT

Link Listing - May 11, 2008

re: SQLBits

Christian — Fri, 07 Mar 2008 09:42:23 GMT

Thanks for the write-up Leo :) I added a post to my blog with a link to the slidedeck here:

http://sqlblogcasts.com/blogs/christian/archive/2008/03/06/my-session-at-sqlbits-ii.aspx

Regards,

Christian Bolton MCA: Database

Database Architect

http://coeo.com - The SQL Server Experts

Return messages during long-running T-SQL Batches

DATALEXIS — Sun, 26 Aug 2007 23:45:19 GMT

Return messages during long-running T-SQL Batches

re: Page splits

Colin Leversuch-Roberts — Tue, 14 Aug 2007 08:35:48 GMT

I've done some "non scientific" testing to see if and how I could slow down inserts, I was trying to prove that adding indexes could slow performance by a measurable amount. So far I've not really had much success, inserting several >8k text columns will slow things , however in the main my inserts to the table were occuring at one end ( like a heap except it wasn't ) the secondary indexes split because I set the data to do that. It's interesting to extract that information and I wish the actual counter had more granularity - as you've suggested it probably has little to do with the issue and I'd sort of agree.