Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

December 2004 - Posts

Wednesday, 22 December 2004 5:22 PM

Swedish SQL User Group website's up

Swedish SQL MVP Tibor Karazi announced the opening of the Swedish SQL Server User Group website yesterday at: http://www.sqlug.se. That's a nice looking website (c: Congrats Tibor & hope the user group is a flying success.
posted by Greg_Linwood | 0 Comments
Tuesday, 21 December 2004 6:26 PM

A database sizing query

I am regularly calculating database sizing details for various tasks & use a few scripts for different scenarios. For example, when investigating a performance problem on a database I've not seen before, I usually grab a snapshot of which are the
posted by Greg_Linwood | 0 Comments
Thursday, 16 December 2004 10:12 PM

Profiler 208 errors & the MVP monthly product issues list

One of the things I like most about the SQL Server MVP program is that MVPs are asked to submit a list of issues every month to our "MVP Lead" - Steve Dybing. Steve takes this list & publishes it to various people & even follows some of the better
posted by Greg_Linwood | 0 Comments
Wednesday, 8 December 2004 11:32 PM

We've got some new friends over in Perth!

I've just been introduced to Brian Madsen by Microsoft IT Pro Evangelist Michael Kleef this week which is exciting enough on it's own, but perhaps a little more to the point, Brian will be organising the first SQL Server User Group meeting in Perth early
posted by Greg_Linwood | 0 Comments
Wednesday, 1 December 2004 7:12 AM

#temp tables and @table variables are NOT in-memory objects

#temp tables and @table variables are often used to optimise stored procedure performance by breaking down large queries (many joins) into smaller units of work or  materialising resultsets to perform additional processing logic in isolation from
posted by Greg_Linwood | 0 Comments