Viewing 15 posts - 31,771 through 31,785 (of 39,749 total)
I certainly could be wrong about BI, but I'm not sure it's the current big thing. It certainly is popular, but I'm not sure if that's few people using it...
July 23, 2007 at 1:59 pm
bump?
If you recompile the proc, meaning changing the code, it should take effect immediately. If you recompiled to get a new plan, that may or may not take effect, depending...
July 23, 2007 at 9:59 am
It's not W2K3. Likely something didn't install correctly. You might try uninstalling the SQL client tools and adding them back.
July 23, 2007 at 9:58 am
I think Litespeed can do this. Not sure about the other backup tools.
There is no way in SQL Server to do this other than restore the database as a new...
July 23, 2007 at 9:57 am
You could write 3 queries and union them. Not sure it would be faster, but possibly. The LIKE is not that efficient compare to other techniques.
Perhaps you could pull off...
July 23, 2007 at 9:56 am
My guess is you're doing too much work in the trigger. Trigger code should be tight and do minimal work.
July 23, 2007 at 9:55 am
I would agree with Sergiy, though I see Kenneth's point.
The reason, in my opinion, that the square brackets came into being was due to extensions to SQL. Many common words...
July 23, 2007 at 9:54 am
Kenneth has the only items I know of (unless you had a trace running).
ApexSQL has ApexLog
Lumigent has Log Explorer
Red Gate has Log Rescue
Probably more out there.
July 23, 2007 at 9:51 am
Thanks. Please put suggestions for other stuff in here. I watch it and often this goes to the developers.
July 23, 2007 at 9:04 am
Al,
Which tool? I've used ER/Studio and ErWin. Didn't like ErWin, like ER/Studio, but both $$$.
July 23, 2007 at 9:03 am
I don't worry about getting rusty, that will drop off fast. Being a good employee, communicating, etc. shines through above technical skills in many jobs. The basic principles of being...
July 23, 2007 at 9:02 am
That's a good one. I'll see if we can get a query for that one.
One of the issues is that we used a purchased forum code so that we didn't...
July 21, 2007 at 10:04 pm
Let's hope. I get tired of moving stuff around ![]()
July 21, 2007 at 10:02 pm
It should, but I didn't trust my high school Latin to find the word ![]()
July 20, 2007 at 9:28 pm
If you figure out the schema tool thing, write me an article. I'd be interested to see that work.
I think some people use it when they do an all...
July 20, 2007 at 10:20 am
Viewing 15 posts - 31,771 through 31,785 (of 39,749 total)