Viewing 15 posts - 1 through 15 (of 18 total)
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...
November 5, 2004 at 12:56 am
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 ...
November 5, 2004 at 12:43 am
It will bring you records 11-20 out of table [myTable], sorted by [sortField]:
select * from (
select top 10 * from (
November 4, 2004 at 1:48 am
Glad to have helped.
September 26, 2004 at 2:15 am
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...
September 22, 2004 at 2:03 am
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...
September 5, 2004 at 1:44 am
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...
June 16, 2004 at 7:15 am
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...
June 16, 2004 at 5:51 am
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...
April 22, 2003 at 12:11 pm
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...
April 21, 2003 at 1:40 pm
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...
April 21, 2003 at 12:48 pm
What about performance impact for this?
Opening a constant trace of my production server doesn't sound right..
April 10, 2003 at 7:10 am
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...
April 5, 2003 at 12:37 pm
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,...
March 23, 2003 at 2:36 pm
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...
September 22, 2002 at 5:47 am