Great article and nice fix. A nasty little error to deal with.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

You have two levels of lockdown:

1) SQL Server Service account

The default install is over the administrator login. Services run with the local system account. What...

Hi

Just thinking aloud here... take care with plan caching, I believe sqlserver is smart enough (BUT), take care with cached plans that are NOT using indexes, as they were cached...

Hi there

This is a classic OP from oracle dba's, but then again, any dbms will benefit from it as your reducing the IO required for maintaining the indexes. Another...

It will reindex the table and all its indexes, nothing else.

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi Andy

Im using my aussie accent and saying.. "thats a bloody great idea mate". The quarterly release with a binder is a unique concept for IT orientated books. ...

Hi there

Yep, its called "SQL Server Web Services", its basically an IIS ISAPI extension + UI that allows you to very quickly create webservers (soap or not) from db stored...

Hi there, the article actually came from my "developers how to guide" for our new VSS framework...funny enough, I had zero comments from the guys hence I was a terrible...

Hi there

declare @object int, @hr int

sp_OACreate is the way to go, along with its associated calls.. eg:

exec @hr = sp_OACreate 'SimpleCDO.Message', @object OUT

-- "SimpleCDO" is the DLL, Message is...

A fair comment Steve.

Thinking about way to protect your apps, the new .net module and handler managed via the http api is a fantastic way of quickly implementing...

Hi

Is it taking more time to insert/update/delete data than to query?

Back to your question, if indexed correctly, you shouldnt have too much of a problem with performance given the dynamics...

Hi all

Funny enough we had a panic session with our apps re sql injection attacks along with cross scripting problems. Generally speaking here, its the tardyness of developers thats...

Hi there

As a matter of course in SQL Server, you should be running dbreindex or indexdefrag on a weekly basis. I have an article coming soon showing the movement...

Hi David

Really depends on your SQL and the complexity of the joins/sql. For example:

select org_id

from organisation as A

inner join Organisation_Name AS B ON B.orgname_org_id=A.org_id

...

Hi Frank

I have to agree with you that the sql server partitioning scheme to enhance performance is a far from optimal model. I generally have a big problem with...