Viewing 15 posts - 2,611 through 2,625 (of 6,216 total)
Decent idea. Im stubborn enough I'd want to make the plans work!
Andy
January 30, 2003 at 2:24 pm
Totally agree you should build it right, then if perf is an issue look for solutions. Keep the table narrow as possible. You might consider summarizing the data daily or...
January 30, 2003 at 2:23 pm
One way is to pause the service. Existing users will stay connected until they finally stop whatever they are doing or you kill the spid. Anyone trying to connect once...
January 30, 2003 at 5:03 am
Doing a select into instead of an explicit create table followed by an insert is one. Using global temp tables might be another. You're seeing deadlocks in tempdb?
Andy
January 29, 2003 at 5:41 pm
You might try running sqlmaint directly instead of via the agent, that if something is going wrong (like a msgbox popping!) you have a chance of seeing it. I've had...
January 29, 2003 at 5:39 pm
Exactly. You can do a select * from sysprocesses where db_name(dbid)='yourdbname', then use the kill command to end the spids. If you have problems with connections being re-established, you can...
January 29, 2003 at 4:17 pm
Im curious why you needed a sequential key but couldnt use ident?
Andy
January 29, 2003 at 4:15 pm
Maybe a timeout in the backup? Lack of disk space? Killing sqlmaint is a great tip, depending on the process not always so easy.
Andy
January 29, 2003 at 4:14 pm
I think the point about deploying hot fixes is a good one. I also think that MS needs to make the fixes a little easier to apply, some of them...
January 29, 2003 at 4:39 am
Nicely done. If you're still in the writing mood, I think an in depth discussion of cross database chaining would be a great follow up.
Andy
January 28, 2003 at 12:14 pm
MS has a free tool called Component Checker that will show all installed versions of the MDAC.
Andy
January 27, 2003 at 10:39 am
Cool. Nothing quite as fun as watching a service pack fail - instant thoughts of "I'll be here all night!".
Andy
January 27, 2003 at 4:47 am
You need dynamic sql to make it work. Build your query and assign to a variable - typically @sql but it doesn't matter, then execute using either Exec(@SQL) or sp_executesql...
January 27, 2003 at 4:44 am
Please don't cross post. Pick the area that seems closest and post once. Thanks.
Andy
January 27, 2003 at 4:41 am
Viewing 15 posts - 2,611 through 2,625 (of 6,216 total)