Viewing 15 posts - 2,506 through 2,520 (of 6,216 total)
Hey, I was ahead for a long time!
Thanks for the feedback. We try to stay involved every day. Used to be we'd comment on almost every question posted, volume grew...
February 21, 2003 at 5:19 am
Can you ping the server? I'd also confirm that they havent changed the port it runs on (look in error log or in server utility on the server).
Andy
February 21, 2003 at 5:15 am
Have the indexes been rebuilt recently? Stats updated? How many other indexes on the table? Does the table have triggers?
Andy
February 20, 2003 at 7:21 pm
Im trying to solve a similar issue. What Im looking at now is about what you've described (limited to procs/views), run a job that scripts out all the objects, adds...
February 20, 2003 at 2:17 pm
Run a job to do the concatenation manually would be one way, either a cmd line copy a.htm + b.htm c.htm, or use file scripting object to do it.
Gotta ask,...
February 20, 2003 at 1:06 pm
Maybe before the delete you had very little free space in the pages, reindexing spread the data out to take up more pages than before. Not sure that accounts for...
February 20, 2003 at 1:04 pm
Nothing built in, was thinking if you needed a subset you'd add code to filter it at run time. Interesting conclusion. Havent dug enough to confirm yet, be more interesting...
February 20, 2003 at 1:02 pm
Porting from another DBMS that is case sensitive?
Andy
February 20, 2003 at 1:00 pm
How about modifying the trigger to write to a log table, or just put a raiserror in the trigger, or even just adding a rollback?
Andy
February 20, 2003 at 9:12 am
Those reminders are handy, I missed the question. Using all should return the contstraints inside an alter statement. Thats enough, or you need to filter it more/differently?
Andy
February 20, 2003 at 9:11 am
I'd say its bad, but you know you'll hit cases where it exists, so not much choice except to use the code you're discussing.
Andy
February 20, 2003 at 9:02 am
Tried running the script manually to see where it breaks?
Andy
February 20, 2003 at 9:01 am
Run sp_updatestats in the production db, that will make sure you get a good query plan. Do you have the exact same indexes in production that you have in development?
Andy
February 20, 2003 at 7:47 am
February 20, 2003 at 7:18 am
Nice article. I agree that it makes sense to put as much of it into one table as you can. We use a similar system, but we added a couple...
February 20, 2003 at 5:05 am
Viewing 15 posts - 2,506 through 2,520 (of 6,216 total)