Viewing 15 posts - 2,446 through 2,460 (of 7,429 total)
quote:
I have a sql2k instance XPDB55 and it has multiple linked servers. 2 of the linked servers are also sql2k and there...
October 29, 2003 at 4:58 am
The answer is no. You can prevent a specific CPU from being used on a multi-processor by turning it off in the server properties.
October 28, 2003 at 11:04 am
The answer is no it does not work like sp_. Here is a bit of info on sp_ http://www.sqlservercentral.com/columnists/jtravis/sp_performance.asp
October 28, 2003 at 10:57 am
quote:
And that's one thing I really appreciate every day !!!!Btw, the book is in my opinion a 'nice to know' surely no...
October 28, 2003 at 5:18 am
quote:
Well to get exactly what you are looking for will take some extra work.But if 123,456.78 is OK try this
...
October 28, 2003 at 5:16 am
With only a part shown it is hard to say why you run into the issue. The part you show would not cause this so I must assume more happens...
October 28, 2003 at 5:11 am
Regardless you should see an increase to I would suggest right at 100% with that much more RAM. Check in task manager and look at how much RAM SQL is...
October 28, 2003 at 4:56 am
quote:
I'm wanting to load a table variable with a query result set ... and then pass the table variable to a function....
October 28, 2003 at 4:49 am
It can only be done if the connector created it. Pretty much done by calling an SP.
October 27, 2003 at 6:06 am
Can you post what you have so we can help based on your need?
October 27, 2003 at 5:12 am
quote:
quote:
uff, and I thought while reading Patricks' post, the programmers of our human resources...
October 22, 2003 at 8:05 am
quote:
I guess I disagree with James ("Antares686") on this; I am loathe to use nullable columns and create them only when I...
October 22, 2003 at 7:49 am
quote:
If you are using smalldatetime you could only use 20790606. What are the chances that they will be using...
October 22, 2003 at 6:26 am
Well I do agree that IF reset @@error since I test without the SP (which should never throw an error that would be trappable in most cases after reviewing).
However to...
October 22, 2003 at 6:06 am
Viewing 15 posts - 2,446 through 2,460 (of 7,429 total)