Viewing 15 posts - 38,176 through 38,190 (of 39,478 total)
Not sure about v6.5. There is a replace in v7/2000. check the BOL on v6.5
Steve Jones
January 30, 2002 at 10:05 am
January 30, 2002 at 9:56 am
I've had some issues with the Copy Database Wizard, so I tend to not trust as much, ubt when it works it is slick.
You can shut down the server and...
January 30, 2002 at 9:53 am
The databases mus be defined as the same size with the same number of devices in v6.5. So the new v6.5 master you create must be EXACTLY the same...
January 30, 2002 at 9:35 am
FYI. I'd change that first. Using Sa, as I'm sure most would agree, is a Worst Practice.
Steve Jones
January 29, 2002 at 12:56 pm
January 29, 2002 at 12:54 pm
Not sure what you mean by "density". High selectivity is a poor choice for the clustered index. In other words, a PK is a poor choice. Each item in the...
January 29, 2002 at 12:53 pm
I've seen this often and been asked the questions myself, but 1000 concurrent users can be extremely taxing or no issue at all. You really have to dig into metrics...
January 29, 2002 at 12:51 pm
I am not sure how T-SQL will become a .NET language, but imagine you could code a front end in T-SQL? Not that you'd want to, but if that's all...
January 29, 2002 at 12:43 pm
Try this. Not sure it is the best or always works.
create table MyTable
( MyID int
)
go
insert MyTable select 1
insert MyTable select 3
insert MyTable select 5
insert MyTable select 12
insert MyTable select 15
insert...
January 29, 2002 at 12:39 pm
Brian has a good explanation for Nulls.
BTW, for items like job, where I might not use the information for people, I tend to normalize this, so instead of having a...
January 29, 2002 at 12:30 pm
Mixed feelings. I hate having something scripted that affects more than one table or update. It prevents you from handling changes to your application that you might not forseen. Maybe...
January 29, 2002 at 12:25 pm
Mixed feelings. I hate having something scripted that affects more than one table or update. It prevents you from handling changes to your application that you might not forseen. Maybe...
January 29, 2002 at 12:25 pm
Andy is away and I'm sure he has some. One nice thing is that in DMO there are methods to accomplish many tasks. In ADO you will have to code...
January 29, 2002 at 12:22 pm
January 29, 2002 at 12:11 pm
Viewing 15 posts - 38,176 through 38,190 (of 39,478 total)