Hi Jeff

Re a), and parameter to local variables. Apparently its something to do with parameter substitution and/or sniffing. See this from Bart Duncal

>>>>>>>>>>>>>>>>>>>>

The reason for the performance difference...

Hi there

This is a strange one.

a) Using parameters? if so, write them to local variables first before using them in your select

b) Try using the recompile option on...

Hi there

Check sysindexes carefully and the statblob column.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

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

Hi there

Unless you have an explicit order by, no matter the indexing in place, sql server will not guarantee the results are returned sorted. Remember that rows must be...

NEVER. Simple as that.

Worst case is an urgent hotfix or some crazy windows issue, but never direct code changes or "playing" around.

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server...

Hi there

The only issue I had was related to cross database ownership chaining. Read up on it if users cross call databases on the instance. One of our...

Hi there, try this:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q307/2/55.ASP&NoWebContent=1

Chris Kempster

http://www.chriskempster.com

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

Hi there

Not that im aware of, sure, connection and command timeouts but not a disconnect timeout. Hunt around on the client provider end, I dont believe there to be...

Hi there

How remote are we talking, inter-company? or over the WAN?

Within your network (LAN) is very simple. The instance itself starts with a listener, the server network utility at...

Hi there

I have an article coming out in a day or two on this website covering off some of the issues. Virtually zero for sqlserver itself though.

Cheers

Ck

Chris Kempster

Hi

The sp_executesql should be fine, use this though to say, write to a variable and check the contents of the variable instead of attempting an IF ..., say, do a...

Hi there

Try this:

Run Regedit

Navigate to \Microsoft SQL Server\80\MSSQLLicenceInfo\MSSQL8.00

edit the Mode value, change to 1

totally unsupported 🙂

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

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

Hi there

I have a 4Gb, i leave around 500Mb free. As a general rule, i try and leave 20% free, but again it depends on what else is running...

Hi all

Pretty boring on my side but...

left high school and attended technical college 3 yrs, then off to uni for another 2 for a degree in comp sci... was actually...

Hi there

I believe the problem is related to your provider and and properties set on connection to the instance. Also, what version are you running and service pack? i...