Viewing 15 posts - 1,471 through 1,485 (of 6,216 total)
We've considered at times branching out a little, but our core competency is SQL so we've been sticking to what we know/do. Maybe someday...!
Andy
October 14, 2003 at 10:04 am
October 14, 2003 at 10:01 am
October 14, 2003 at 10:00 am
What happened? Applying a sp shouldnt change your role membership.
Andy
October 14, 2003 at 9:59 am
Depending on what you want to accomplish you might want to use sp_addalias instead. The difference being that with an alias, the 'are' the dbo. The difference (minor) is that...
October 14, 2003 at 5:06 am
What about changing the seed to a negative? Int's have a upper bound of 2 bil or so, but they also have a lower bound of -2 bil.
Andy
October 14, 2003 at 5:04 am
40k? Wow.
I don't know of a way to suppress it. Would fixing it be that difficult?
Andy
October 14, 2003 at 5:00 am
Command timeout should do it, though I never change in the connection string but rather at the command object itself.
Andy
October 14, 2003 at 4:59 am
The first idea that comes to mind is to write your own "replication". The approach I've used in the past is to use triggers (don't know if you have them?)...
October 14, 2003 at 4:57 am
Good discussion. I tend to use surrogate keys. I share the view about int's vs guid's. I use both, but so far inconsistently. My current plan is that if I...
October 14, 2003 at 4:54 am
Not a bad start. I definitely recommend 2 days on disk if you have the space, the reason is that sometimes the backup to tape (you didnt mention, but a...
October 14, 2003 at 4:47 am
Not a question with a one sentence answer. Basically both are data stores. If you're just starting out you might consider using Access (or a similar product). Basically you're trying...
October 13, 2003 at 10:49 am
Whats your disk utilization and queueing look like? Sometimes raw speed counts. How many drives are you going to have in what configuration?
Andy
October 13, 2003 at 10:43 am
MS Press has one of the Step by Step books on ADO.Net that has examples in C#, decent place to start.
Andy
October 13, 2003 at 10:42 am
I don't have access from where I am, I'll get someone to check.
Andy
October 13, 2003 at 4:13 am
Viewing 15 posts - 1,471 through 1,485 (of 6,216 total)