Browse by Tags

All Tags » SQL Server 2005 (RSS)
Vital Statistics – free webcast now available
02 February 10 10:53 AM | Christian | with no comments
Another one of my sessions from SQLBits V, this time on SQL Server Statistics. You can it from the SQLBits website: http://tinyurl.com/yb2t2v5 The presentation was based on information that you’ll also find in my latest book, Professional SQL Server 2008...
Filed under: , , , , ,
Webcast Now On Demand: The 5-Minute SQL Server Healthcheck
16 November 09 08:59 PM | Christian | 1 comment(s)
I joined Kevin Kline from Quest on Thursday for a webcast on "The 5-minute SQL Server Healthcheck" which is now available online. I hope you find it useful! http://www.quest.com/events/listdetails.aspx?contentid=10581&technology=34&prod...
Filed under: , , ,
SQL Server Standard 'Lock pages in memory' workaround coming soon...
24 April 09 10:47 AM | Christian | with no comments
Bob Ward just announced at European SQL PASS that you'll be able to use the 'lock pages in memory' workaround in SQL Server Standard Edition to resolve working set trimming issues. In the next CU releases for SQL Server 2005 and 2008 you'll...
Filed under: ,
FREE one-day seminar on Optimising SQL Server Performance
08 March 09 01:54 PM | Christian | with no comments
I’m going to be joining Quest Software on 24th March for a seminar on Optimising SQL Server Performance at the Quest offices in Maidenhead, Berkshire. Attendance is FREE and you’ll get a chance to try out Quest’s product range with hands-on-labs: BOOK...
Filed under: , ,
A walk down memory lane, SQLBits Video now available
10 November 08 01:30 PM | Christian | with no comments
After surprising me with a camera crew and a lighting rig when I turned up to present my session at SQLBits in September, Microsoft have finished editing the footage and the finished result is now available. Fortunately for me they've done a great...
Filed under: , , , , , , ,
Temporary object re-use "nugget" at the UK SQL Server User Group
21 October 08 08:30 PM | Christian | with no comments
I presented a 5 minute nugget on temporary object re-use at the UK SQL Server User Group last week and I promised that I'd follow it up with a post so here it is! As of SQL Server 2005 temporary objects are now cached by default as long as Named constraints...
Filed under: ,
A walk down memory lane at SQLBitsIII
17 September 08 03:38 PM | Christian | with no comments
[Update 5th Nov 08] New download link added Thank you to everyone who attend my session on memory at SQLBits on 12th Sept. I really enjoyed it and judging by the feedback many of you did too. You can download the slideshow and pdf from our website: http...
Filed under: , , , , ,
LiveDataScript: Scripting data from a database into insert statements
30 July 08 09:50 AM | Christian | with no comments
We've partnered with a company called Live Software Solutions on a number of projects recently and they've just decide to release a great tool we've been using on a number of projects as a free download. It allows you to generate a single...
Filed under: ,
Customer Advisory Team - BizTalk Server Performance Optimization Guide
09 July 08 01:20 PM | Christian | 1 comment(s)
We've been doing some work with the BizTalk Customer Advisory Team at Microsoft to help develop official guidance for SQL Server in a BizTalk environment. This has just been launched as part of the Microsoft BizTalk Server Performance Optimization...
Filed under: ,
Will you still want me, when I'm 64?
29 April 08 09:44 AM | Christian | with no comments
[Update 5th Nov 08] New download link added Thankyou to all those who attended my session on 64-bit SQL Server at the UK SQL Server User Group on 17th April 2008. I've just got round to uploading the slidedeck for those of you that have been asking...
Filed under: , , , ,
My session at SQLBits II - What Are You Waiting For?
06 March 08 09:05 PM | Christian | with no comments
Thankyou to all those who attended my session "What Are You Waiting For?" last Saturday at SQLBits II in Birmingham. There was some great feedback and constructive comments which I will incorporate when I deliver the session at the European...
Filed under: , ,
Professional SQL Server 2005 Performance Tuning released
27 January 08 03:36 AM | Christian | with no comments
http://www.amazon.co.uk/gp/product/0470176393/ref=s9_asin_title_1?pf_rd_m=A3P5ROKL5A1OLE&pf_rd_s=center-1&pf_rd_r=1H851J8GCPJE25PHWM77&pf_rd_t=101&pf_rd_p=139045791&pf_rd_i=468294 I've had a couple of e-mails from people in the US...
Filed under:
SQL Server memtoleave, VAS and 64-bit
07 January 08 11:39 AM | Christian | 6 comment(s)
GrumpyOldDBA started a nice thread here: http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx on 64-bit which I began to reply to but it got big enough for a full post. This is a great topic to...
Filed under: , ,
SQL Server: resource waits and signal waits
14 November 07 04:24 PM | Christian | 2 comment(s)
You won't find any resource waits that specifically measure CPU wait time, instead you measure “signal waits” which have been conveniently worked out for you in SQL Server 2005 and exposed in the sys.dm_os_wait_stats dmv. Specifically, a signal wait is...
Filed under: , ,
How to corrupt a page in a specific index and then fix it
07 October 07 10:19 AM | Christian | 1 comment(s)
I was developing course materials for a workshop recently and I wanted to run a lab where you DBCC’d a database, found an error and then worked out how to fix it. The only problem was deliberately corrupting a page in a specific index. I did some investigating...
Filed under: ,