Browse by Tags

All Tags » Performance (RSS)

SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience...

Must attend training day for anyone serious about SQL

I was in Denmark earlier this year speaking at Miracle Open World and I heard about a guy that had done a session the year before about the internals of PDF files. This year he was doing the one on MDF files. This was a must see, so I popped along. Mark...

SQL Azure Federations and Semantic Search by the SQL product team in London tonight (Monday)

Don’t forget that tonight we have Michael Rys from the SQL Server Product Team presenting on the Federation support coming to SQL Azure and the Semantic search coming in SQL Server Denali. This is a must attend evening for anyone that is serious about...

How to make your laptop 10 times faster

For a while now I’ve been struggling with the performance of my laptop. Over time it starts to run slowly videos play really badly and anything that is CPU bound just takes ages. Anyone thats seen my demos recently might have seen some erratic behaviour...

Sharding in SQL Azure

The federation (sharding) support in SQL Azure is almost upon us. This was introduced at PDC in October last year http://www.msravs.com/audiosearch_demo/default.aspx?&index=Microsoft_PDC&q=federation&qr=All If you want to read about the federation...
Posted by simonsabin | 1 comment(s)
Filed under: , , ,

Next generation Data Warehouse : Free London Event

Are you working in Data Warehousing then this event might be for you. Together, Microsoft and HP are engineering an innovative product range that combines our leading edge software and hardware assets into optimized data-warehouse appliances. In addition...

The optimiser should understand that year(datecolumn) is correlated to the datecolumn

If you have a query such as select year ( OrderDate ) yr , count ( 1 ) from AdventureWorks2008 . Sales . SalesOrderHeader group by year ( OrderDate ) and you have an index on OrderDate you will find that even though the query optimiser could do a stream...

What are the Crappy Code Games - Tips on how to win?

This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win Tips on how to win Each test has some different aspect that will define how you win....

What are the Crappy Code Games - Why should I attend?

This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win Why should I attend? The crappy code games isn’t all about winning, its also about having...

What are the Crappy Code Games - What are the prizes?

This is part of a series on the Crappy Code Games The background Who can enter? What are the challenges? What are the prizes? Why should I attend? Tips on how to win What are the prizes? There are loads of them at both the heats and the final. At the...
More Posts Next page »