GilaMonster (10/22/2007)

---

If your clustered index is on a column that doesn't increment (identity, date inserted) then inserts cause page splits. Page splits cause increased IOs and index fragmentation. Fragmentation causes...

Well - it's an interesting article, but does seem to miss covering a LOT of issues/concerns. For example - part of the "aging staff" would be the mainframe programmers,...

sheesh I go away for the weekend, and there's a testing war started? hehe...

Jeff - for what it's worth: if you changed your indexing scheme - OVER (Partition...) works...

Yeah - I call them - "not being in charge of your destiny":

- projects you inherited that aren't good;

- third-party apps that s**k data-wise,that you...

1.Reading a record at a time versus inserting in bulk will lengthen your process something awful. It will take more resources, piss the server off for longer...(In short -...

As far as I can remember:

Windows 2003 R2 has been around since Sep 2006

SP2 (both for R1 and R2) has been around since Nov. 2006.

Windows R2 was built to...

I realize it's a tad bit late since you've already downloaded the 268MB version...but there was a standalone SSMS Express (just SSMS, not the whole thing) download out there. ...

Jack Corbett (10/19/2007)

---

I am with Jeff in that I always look for a set-based solution to a data problem avoiding cursors and loops as much as possible, even if I'm...

Wow - lot to handle here

Jeff Moden (10/19/2007)

---

Just to clarify, my point was meant to say the following rather than do a "cage match" over a couple of seconds... 'cause...

from the UI side, right-click on the user, and go into properties.

If you don't have access to the PW, then it's a windows user. Change those from the OS.

If it's a third-party application... you really should talk to them about getting a data dictionary and/or whatever you wish from them. Some third-parties get very squirrely when you...

Sergiy - you missed my response to Jeff. Short answer - on the same platform (hardware+table+indexes+data spead) - they tie, or at least are close enough to consider either...

As to the main topic - did my degree in Computer Science in two swipes.

Cut my teeth on Pascal, Ansi C, Prolog/Lisp in the GNU/EMACS ENIAC environment the...

Sergiy (10/19/2007)

---

Bloody site!

Wiped...

FYI - for those interested... The "flagged" version looks like this.

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Imports System.Text.RegularExpressions

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction(IsDeterministic:=True, IsPrecise:=True)> _

...