Browse by Tags

ProClarity 6.3 available on MSDN downloads

I've just logged into MSDN downloads and was very shocked to see ProClarity available for download. Both server and desktop versions are available. You can read more on Proclarity here http://www.proclarity.com/ - var height=90;var width=720;

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Apr 4 2007
SQL Server 2005 Best Practices Analyzer

All SQL Server 2005 Best Practices Analyzer (February 2007 CTP) is available now for Download . Thanks Sutha

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Thu, Feb 22 2007
Download Feb 2007 Books Online

There is an updated version (February 2007) of Books Online available for download . Thanks Sutha

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Mon, Feb 19 2007
SQL Server 2005 SP2 is available for download

All SP2 is available for download now. Thanks Sutha

Posted to Sutha's SQL BI Blog (Weblog) by tsutha on Mon, Feb 19 2007
Two Free MSDN Team Suite Subscriptions

If you want to win one of two MSDN Team Suite Subscriptions worth in excess of £5,000 then its simple. Start contributing the SQL Blog sitte sqlblogcasts.com and you'll be in with a chance. Its free to join up and start blogging so whats stopping you. To learn more read Tony's blog. Free MSDN...

Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Nov 12 2006
Native Command Substitution is not supported

In response to a recent support incident we raised we got a response about use of detours in SQL Server. A detour is a means by which you can change what SQL Server does. This is used by Litespeed to change native backup commands into Litespeed backup commands. Whilst I always thought this a neat idea...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 5 2006
Is IDENT_CURRENT the next @@identity

I've just finished watching the webcast on building a wareshouse according to Kimball principles. In it they generate an audit record by inserting a record and then using IDENT_CURRENT to get the identity value. A few months ago some one on the forums was screaming because the IDENT_CURRENT was not working...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 11 2006
A large slice of humble pie please Mr Thomson

In my presentation last night I went through a process by which you can create Raw files so that you can append to them in a for each loop as there is no "Create once for the package" setting for a Raw file. I knew Jamie had covered this in his blog but I was doing a slightly different approach and Jamie...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Jun 23 2006
Are you allowed to be sizeist in the database world

Well even if your not, one of my real bug bears is fat tables. These aren't large tables they are fat tables, wide ones with lots of columns or large data types. The reason this gets is is people develop databases with 10s of rows in them. Then end up with millions of rows in them in a live environment...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, May 25 2006
Performance of MAX trick

Jamie posted a comment to by post about the trick for finding a maximum value in a set of results. Stating that the CASE statement solution was significantly faster. Being a synic I didn't believe him so tried it out for myself The following are the two sets of code, and below that is a script to populate...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 16 2006

Page 3 of 5 (47 items) < Previous 1 2 3 4 5 Next >