Browse by Tags

Will you still want me, when I'm 64?

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 for it. You can download it here: http://coeo.com/conferences.html . For anyone interested that...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 04-29-2008
MCITP - I passed the 70-446 “PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam!

Today I passed the Microsoft IT Professional(MCITP) 70-446 “ PRO: Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005” exam. This makes me one of the 337(January, 2008) Microsoft Certified IT Professionals worldwide! ( Nr. of MCP's worldwide ) To try the 70-446 exam...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 03-28-2008
Set based splitting of delimited strings to columns

I recently presented on using CLR in SQL at DevWeek and commented on how TSQL Udfs just don't perform. A common scenario people in the audience were using TSQL Udfs for was splitting delimited strings. One guy asked me afterwards what the best way to do it was, he had addresses in one field he wanted...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 03-17-2008
My session at SQLBits II - What Are You Waiting For?

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 SQLPASS conference next month in Germany ( http://www.european...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 03-06-2008
SSIS – Non-blocking, Semi-blocking and Fully-blocking components

How can you recognize these three component types, what is their inner working and do they acquire new buffers and/or threads? Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or fully-blocking. Before I explain how you can...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 02-27-2008
SQL Server 2008 – iFTS Introduction

This is the first of a series of posts on the new Integrated Full Text feature in SQL Server 2008. This is one of my favourite features which I’ve had to keep stum about for quite a while. Firstly an introduction to full text. Full text is the feature in SQL Server that allows you to search text content...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 02-19-2008
Table Valued Methods on Type

I amd really getting into the use of UDTs as a way of packaging up SQL CLR code. I'm also looking into implementing an array type so I can do code like declare @s dbo . SQLArray set @s . AddKeyword ( 'sas' ) set @s . AddKeyword ( 'dog' ) Fo this to be realy useful you would want to be able to select...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 02-15-2008
SSIS – Lookup Transformation is case sensitive

A while ago I figured out that the lookup transformation is case sensitive. I used a lookup to find dimension table members in for my fact table records. This was done on a String business key like ‘AA12BB’. I attached a table for the error output and after running the package I found one record in this...

Posted to Jorg Klein's Microsoft Business Intelligence Blog [Macaw] (Weblog) by jorg on 02-12-2008
How to change My PK to Identity?

I am making some improvements to a system that I didn't write. We have lots of tables which do not use the IDENTITY property - but these tables are using integer surrogate primary keys. The primary keys are assigned using a stored procedure from a key table. This is an ugly, horrible disgusting solution...

Posted to Mark's SQL Server Blog (Weblog) by MarkAllison on 01-30-2008
Linked Server timeouts

I had a puzzling little problem this week which caused our remote users unable to access our system in our remote location. We have two SQL Server 2005 SP2 servers on different continents. The link between them is extremely slow around 100kbit. We have a linked server set up on the remote server, let...

Posted to Mark's SQL Server Blog (Weblog) by MarkAllison on 01-29-2008

Page 1 of 20 (194 items) 1 2 3 4 5 Next > ... Last »