SimonS Blog on SQL Server Stuff - All Comments

SQL Server 2008 ??? iFTS Introduction - SimonS Blog on SQL Server Stuff « Catnippet

Mon, 12 May 2008 16:49:51 GMT

Pingback from SQL Server 2008 ??? iFTS Introduction - SimonS Blog on SQL Server Stuff « Catnippet

sql cursors

sql cursors — Wed, 07 May 2008 13:36:11 GMT

Pingback from sql cursors

DBMS2 — DataBase Management System Services » Blog Archive » XML versus sparse columns in variable schemas

Fri, 25 Apr 2008 04:11:17 GMT

Pingback from DBMS2 — DataBase Management System Services » Blog Archive » XML versus sparse columns in variable schemas

mcsd

mcsd — Mon, 21 Apr 2008 07:12:29 GMT

Pingback from mcsd

sql select column value by column number

sql select column value by column number — Sun, 20 Apr 2008 20:23:50 GMT

Pingback from sql select column value by column number

sql replace substring

sql replace substring — Sun, 20 Apr 2008 19:50:53 GMT

Pingback from sql replace substring

iFTS bug in CTP6 « SQL Dev’s Playground

iFTS bug in CTP6 « SQL Dev’s Playground — Mon, 14 Apr 2008 14:53:35 GMT

Pingback from iFTS bug in CTP6 « SQL Dev’s Playground

Pages tagged "layout"

Pages tagged "layout" — Thu, 03 Apr 2008 07:47:28 GMT

Pingback from Pages tagged "layout"

re: Yippee I've been reawarded as an MVP

Madhivanan — Thu, 03 Apr 2008 07:18:40 GMT

Congratulations Simon

I am on a quest for a idera..err..idea of new feature. Could it be just beyond the red gate?

TrackBack — Thu, 03 Apr 2008 05:25:50 GMT

Reflective Perspective - Chris Alcock » The Morning Brew #64

Reflective Perspective - Chris Alcock » The Morning Brew #64 — Wed, 02 Apr 2008 06:28:04 GMT

Pingback from Reflective Perspective - Chris Alcock » The Morning Brew #64

Dew Drop - April 1, 2008 | Alvin Ashcraft's Morning Dew

Dew Drop - April 1, 2008 | Alvin Ashcraft's Morning Dew — Tue, 01 Apr 2008 12:18:30 GMT

Pingback from Dew Drop - April 1, 2008 | Alvin Ashcraft's Morning Dew

SQL Server 2008 - HierarchyId - How do you move nodes/subtrees around

SimonS Blog on SQL Server Stuff — Mon, 31 Mar 2008 14:43:29 GMT

In a recent post SQL Server 2008 - HierarchyId whats the point? I talk about the scenarios that the new

Dew Drop - March 26, 2008 | Alvin Ashcraft's Morning Dew

Dew Drop - March 26, 2008 | Alvin Ashcraft's Morning Dew — Wed, 26 Mar 2008 14:00:46 GMT

Pingback from Dew Drop - March 26, 2008 | Alvin Ashcraft's Morning Dew

re: LINQ to SQL Gotchas - Using Stored procedures

simonsabin — Tue, 25 Mar 2008 21:46:17 GMT

It my be my misunderstanding of how a data reader works.

The big issue with client side cursors was the overhead in network round trip in calling sp_cursorfetch (or something similiar) and most hadn't change the default fetch size so it did one per row.

That meant that perf sucked full stop. However with a data reader I believe the behaviour is different.