Ha!

This seem to be a known Microsoft bug - see article at http://support.microsoft.com/kb/246201/EN-US/

I tried tha sample statement they provide in the article and it indeed seems to be it...

As a matter of fact, both servers are not EXACTLY the same version - seems to be a change of build number and date.

the OK one is:

Microsoft SQL Server ...

Try this:

It will bring you records 11-20 out of table [myTable], sorted by [sortField]:

select * from (

    select top 10 * from (

        select...

Glad to have helped.

 - Avi

I had same sort of problems once, and it turned out that we had to play with the way our client was connecting to the server, i.e. multiprotocol/named-pipes/TCPIP.

Try specifying different...

As for the article, I was expecting to see some insight on runtime performance using triggers vs SPs. For instance, from my own experience I found that using INSERTED from...

Thanks Bryant.

Do you know what kind of index is created automatically when creating a FK? is this some sort of an implicit index or can it be scripted from EM like...

On the same note:

I was once told that creating a forein-key constraint upon two tables causes an implicit creation of some indexes that can speed up joins on the FK...

From the gent with the ORs to David.Poole (or anyonw who may wish to comment on this one):

I'll definitely try your suggestions for making the queries faster - but you...

I've tried an approach of sending optional params (with default value=NULL) to the Search-sproc, and in it using a single-static SELECT statement with lot's of OR operators in the WHERE...

It seems to me the msgbox is hanging your script.

When SQLAgent tries to execute a msgbox(), the msgbox appears on the SERVER SCREEN (if you have a pcanywhere/vnc to your...

What about performance impact for this?

Opening a constant trace of my production server doesn't sound right..

I sometimes find that NULL values behave funny in IN statements..

maybe you have a NULL value in your 'custlog.topic' field?

This kind of thing may get you a no-resulter, as opposed...

How about the SQLEXECMS util?

it gives you tree-views, object-comparison (schema, no data), server-status (disk etc.) , dependencies, and autocpmplete in the SQL panel :->

No to mention exporting recordsets to excel,...

How would I access this transaction?

what would be the syntax (i.e. "rollback tran <tranName>"...)

Also, how are these transactions' attributes configured (or are they hard-coded)?

I tried checking the status of one...