Viewing 15 posts - 376 through 390 (of 484 total)
From BOL:
DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
March 25, 2005 at 1:40 pm
Not sure what the "ID:Q167833" is, as that is not listed anywhere as a connection property (might have been WSID: if your workstations are named in that format?).
"Network Library=DBMSSOCN", is...
March 25, 2005 at 1:18 pm
1) You are probably right on about Permissions, but it is the permissions of the account running the job. Check the account that SQLServer Agent service is using, and for...
March 25, 2005 at 1:00 pm
As a consultant that advises and maintains dozens of clients on their SQL Server systems and problems, my favorite answer for this is unfortunately not listed. This option is not referred...
March 25, 2005 at 5:29 am
Remi;
>...this will cause sql server to make a cross join of 90 000 000 000 records ...
That is not quite correct. Assuming (as you did) that Shelly had the type...
March 15, 2005 at 9:35 am
Nicolas, Kenneth;
I think Michaels example in the first post in this topic was not best for what he was trying to explain. If TableA had 3 rows, he would want the...
March 15, 2005 at 9:02 am
The first version: I'm a little surprised it would work at all. You are only putting in parts of the where clause if the parameter would have a value (e.g....
March 15, 2005 at 8:39 am
Dave;
>This produces over 4 million logical reads! My solution reduces it to about 12,000.
Certainly if testing shows one way is better than another, go for it. It seems like, no...
March 14, 2005 at 5:31 pm
No problem. I just assummed it was Yukon because of the category the post was in.
700 extents is not ideal, but it is not too many. I've seen dbs where...
March 14, 2005 at 1:07 pm
The syntax for sp_executesql is for passing parameters to fill into a query, not for passing SQL clauses. You cannot put an entire Where clause in as a parameter. You...
March 14, 2005 at 12:45 pm
Sounds like your database is somewhat fragmented, and perhaps Yukon is not tuned well enough to handle that (yet).
You are not using Yukon (a beta product) for 80 users in production,...
March 14, 2005 at 11:50 am
I don't know how efficient this will be, and it may drag down your performance if the resultset is too large, but how about using the Top clause in a...
March 14, 2005 at 11:41 am
Why settle for one hugely expensive monitor. Just buy a few cheap ones.
http://members.chello.nl/~s.ferris/
Had to laugh when I saw the seatbelt.
March 11, 2005 at 5:07 am
Possible problems:
March 10, 2005 at 6:57 am
Viewing 15 posts - 376 through 390 (of 484 total)