Viewing 15 posts - 2,026 through 2,040 (of 6,216 total)
I agree with Steve, we'd like and are working on some changes, but with a limited of time to apply, we have to pick and choose. Part of it too...
June 19, 2003 at 2:59 pm
I don't know how much overhead is associated with SQL handling a table with 3000 columns instead of 20, but if your rows are mostly used (close to 8k) the...
June 19, 2003 at 3:41 am
Thanks for the note. We'll add to a long list!
Andy
June 18, 2003 at 8:54 am
That's Brian K doing that, he randomly pops a search string submitted by someone up there.
Andy
June 18, 2003 at 8:53 am
The easiest way is to build the statement and execute at run time. If you want to do in a procedure, you'd do something like this:
@sql='select * from table where...
June 17, 2003 at 5:55 am
You could email using xp_sendmail - assuming that the user could be resolved to an email address, or you could use net send to send a message to the host...
June 16, 2003 at 11:08 am
Havent heard anything - then again, I don't have any inside scoop!
Not sure personal tempdb's would work if actually implemented as db's, imagine a box with 4000 concurrent users!
It would...
June 16, 2003 at 4:27 am
Nope. You have to get everyone disconnected. A shame they don't offer the option. For example, if you have replication running, you have to stop the log reader.
Rather than worry...
June 16, 2003 at 4:22 am
Probably DMO. You can loop through each trigger, process triggers that match your pattern, do the alter.
Andy
June 16, 2003 at 4:15 am
Crosspatch, why do you consider the command object clumsy?
Andy
June 16, 2003 at 4:14 am
A view is usually a good way to do this. You can either change the table and use a view to make it look as though nothing has changed, or...
June 15, 2003 at 3:54 pm
I'd agree that it's an accepted best practice to have a primary key on each table. What the key should consist of is usually where the fun begins. Some opt...
June 14, 2003 at 9:57 pm
Typically you only add additional parens to make the logic correct. Don't know there is a best practice here. I work to solve the problem - write a query that...
June 14, 2003 at 3:07 pm
Some comments:
1) You're bringing back a LOT of data. Compare the run times just bringing back a pkey or whatever, you'll see the difference. If you have to have it,...
June 14, 2003 at 11:20 am
ODBC trace enabled maybe? I'd expect perf to be the same or better after running update stats. Tried a reboot to be sure you're clean?
Andy
June 12, 2003 at 6:03 pm
Viewing 15 posts - 2,026 through 2,040 (of 6,216 total)