Viewing 15 posts - 1 through 15 (of 18 total)
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...
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
Try this:
It will bring you records 11-20 out of table [myTable], sorted by [sortField]:
select * from (
select top 10 * from (
select...
November 4, 2004 at 1:48 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
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...
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
Viewing 15 posts - 1 through 15 (of 18 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy