Viewing 15 posts - 5,476 through 5,490 (of 6,216 total)
David, I'd avoid running things in a trigger if you can help it. Really it depends on the frequency, but you don't want triggers to be long operations. Typically I'd...
November 7, 2001 at 1:46 pm
If the remote connection is Enterprise Manager or Query Analyzer, it should be fine. You just cant have connections to the database you want to detach.
Andy
Andy
November 7, 2001 at 5:17 am
Why do you care if it recompiles? Do you execute this a lot?
Andy
Andy
November 7, 2001 at 5:15 am
If you just need VB functionality and not truly extend TSQL with an extended stored proc, then Paul is on the money - compile to a dll, you can execute...
November 7, 2001 at 5:14 am
That said, you would nchar or nvarchar if you think you'll need to internationalize at some point. If you're not going to, use char or varchar - they take up...
November 6, 2001 at 2:02 pm
The standard maintenance plan generated by the wizard in EM fulfills most of my needs.
Andy
November 6, 2001 at 1:58 pm
Double check the connect string and look to see how it's showing up in sp_who. If you get the string wrong, it can change back to a trusted connection.
Andy
November 6, 2001 at 11:59 am
Used for some testing, had no problems, but have not used them in full production. They are nice, but a niche feature to me.
Andy
November 6, 2001 at 9:31 am
I believe the default is to leave in 6.5 mode. Which makes sense, you get the improvements of 7.0 (most of them) while not breaking your app. I'll agree they...
November 6, 2001 at 9:30 am
But how much longer would it take to do it "the right" way?
Andy
November 6, 2001 at 9:26 am
In over simplified terms, clustered indexes are both more effective for range searches and they increase the effective of your other indexes to some degree. Look for an article in...
November 6, 2001 at 5:51 am
Is it bad to connection global.asa? If so, why? Thought it was only basd to store connection (or other object) in a session variable?
Andy
November 6, 2001 at 5:25 am
People skills is ok, but I vote for someone who can take constructive critiscm and mentoring in the spirit it was intended. If you can find someone who will listen...
November 6, 2001 at 5:24 am
You're welcome! Thanks for participating.
I think it makes sense to do the group by, you don't want to issue a query for each time region. Once you have the group...
November 6, 2001 at 5:17 am
It's a sort of feature, gives you some flexiblity. Im not aware of any tool.
Andy
November 6, 2001 at 5:13 am
Viewing 15 posts - 5,476 through 5,490 (of 6,216 total)