Viewing 15 posts - 37,891 through 37,905 (of 39,720 total)
If you haven't read this, it's interesting:
http://www.softwaremarketsolution.com/
from the maintainer of http://www.joelonsoftware.com
Steve Jones
April 4, 2002 at 8:41 pm
Is that true? I thought all comms were across that port. Need to check this out.
Steve Jones
April 4, 2002 at 8:33 pm
There is a white paper on performance tuning here:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
I think there will be a variety of factors. It seems that the write size of Windows will have something to do...
April 4, 2002 at 6:14 pm
You can by storing the id value in a @var and then incrementing by selecting the min(id) where id > @id.
Steve Jones
April 4, 2002 at 2:21 pm
Or send in all the values for the params to one procedure and have that one call the appropriate procedure to do what you want.
Steve Jones
April 4, 2002 at 2:13 pm
April 4, 2002 at 2:06 pm
It was buggy and IMHO, that is why they made it the non-default.
Probably a registry setting, but I have no idea which one.
Steve Jones
April 4, 2002 at 2:05 pm
We do this with categories here at SSC.
create table Category
( categoryid int
, categoryname varchar(20)
, parentcatid int
)
insert category 1, 'SQL 2000', 0
insert category 2, 'Programming', 0
insert category...
April 4, 2002 at 1:09 pm
yes,
create view N_orders as
select *
from northwind.dbo.orders
return
create this in pubs to access northwind.
Steve Jones
April 4, 2002 at 1:06 pm
Is this a valid path on the server? THe with MOVE is to restore from a different path than that the backup was made with. This applies to different servers...
April 4, 2002 at 1:01 pm
they both will work well. The IN resolves to essentially a series of ORs
Steve Jones
April 4, 2002 at 12:59 pm
Is the problem that SQL Server sometimes runs on 5000? Is this an instance besides the default? The server network utility mentioned above allows you to limit SQL Server to...
April 4, 2002 at 9:53 am
If you don't have the need for a SAN, I'd stay away. You are spending $$ and taking chances for no reason. SANs are usually looked at for the 100s...
April 2, 2002 at 4:43 pm
Personally I use Box C as a QA box, backup/restore box A to box C, deploy code, and test. If everything is ok, then deploy code to box A and...
April 2, 2002 at 10:53 am
Viewing 15 posts - 37,891 through 37,905 (of 39,720 total)