Viewing 15 posts - 1 through 15 (of 122 total)
This is exactly what I was looking for.
How can I incorporated into a SP that will return also the result set?
Thanks so much for the help,
May 2, 2008 at 12:57 pm
Absolutely sure - This is the error returned to the applciation:
[Microsoft][SQL Native Client][SQL Server]Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim....
April 11, 2008 at 3:21 pm
Thanks a lot for your post. It took me a while as the project was on hold for several months.
What I really need is equivalent of the OUTPUT clause in...
November 28, 2007 at 6:08 pm
It looks that SQL server 2005 is picky - the problem was in the way the luns were setup - as soon as the permission's were updated in Disk...
November 14, 2007 at 4:26 pm
Thanks a lot for the replay.
But why SQL 2000 doesn't require that?
Is this 2005 limitation, or depends on the edition - Standard?
Thanks a lot, mj
November 14, 2007 at 10:52 am
Have connectivity issues right now.
I'll post the queries as soon as I could connect to the box.
Sorry about that.
November 5, 2007 at 9:27 am
Yes, I did but nothing really changed.
I used this command to do it:
UPDATE STATISTICS er_account WITH FULLSCAN, NORECOMPUTE
November 5, 2007 at 9:13 am
Thanks a lot, but unfortunately, the server is correctly configured... Both TCPIP on server and client. Also, in the Surface Area, both Remote and Local connection, TCPIP and Named Pipes...
October 21, 2007 at 10:30 pm
I do not believe that this is an issue of using bind variables or literals.
Please, note that the slow statement is the one that uses bind parameters, not literals. I...
September 30, 2007 at 6:47 pm
This is what I have tried but I still cannot create unique index on the view because there are repetative values and I cannot use distict.
So still doesn't work for...
August 10, 2007 at 10:42 am
All indexes are rebuilded and the stats are updated.
The execution plans show that the optimizer uses FTS on the Name table coming from the NAME_view which makes no sense to...
August 7, 2007 at 12:10 pm
This is my SQl server version after I have applied SP2 - 9.00.3042.
I saw some higher numbers in the previous replies - like 3061. How to get to this numbers...
August 3, 2007 at 12:28 am
Any advice on how exactly to configure the memory on 64 bit?
So far I have 8GB for the OS and did not limit then after reading (or misreading) the...
July 30, 2007 at 8:18 pm
Thanks a lot.
yes, the application uses transactions.Unfortunately, I cannot use uncommitted transaction. For a while I'll be on SQl server 2000 (2005 is scheduled for late 2008) so I have...
June 27, 2007 at 9:01 am
I tried the advice to use clustered indexes, and still do not see any improvement in the inserts. Systematically seeing reads on them as the example above.
Investigated the connection from...
June 20, 2007 at 9:57 am