Viewing 15 posts - 38,416 through 38,430 (of 39,720 total)
I think this is ok, but I am wary of the appending. I always write a new t-Log backup and overwrite so that I have multiple files to restore, but...
January 30, 2002 at 10:20 am
January 30, 2002 at 10:07 am
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
Viewing 15 posts - 38,416 through 38,430 (of 39,720 total)