Browse by Tags

All Tags » SQL (RSS)

Loads of things going on at #SQLBits

Wow its been a busy few weeks in SQLBits land. Session Voting We’ve opened up voting for the sessions for SQLBits 10 http://sqlbits.com/information/PublicSessions.aspx Make sure you vote so we pick the sessions you want. You’ve got to register on the...
Posted by simonsabin | 2 comment(s)
Filed under: ,

SQLBits evening do

We have finally got finalised that, at SQLBits, we will be having a drinks reception after the sessions finish. There will FREE beer (other drinks will be available) and pizza. We've also got some entertainment planned so it should be a good evening...
Posted by simonsabin | with no comments
Filed under: , ,

To cluster of not

Tony's blogged about the use of heaps http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/24/row-fragmentation-hopscotch-heap-v-clustered-and-io-cost.aspx . Whilst this highlights data on a page being out of sequence and thus yoyoing when you...

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 by simonsabin | 1 comment(s)
Filed under: ,

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...
Posted by simonsabin | with no comments
Filed under: , ,

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...

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...
Posted by simonsabin | 1 comment(s)
Filed under: , ,

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...
Posted by simonsabin | with no comments
Filed under: ,

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...
Posted by simonsabin | with no comments

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...
Posted by simonsabin | with no comments
Filed under: ,
More Posts Next page »