Viewing 15 posts - 42,766 through 42,780 (of 49,571 total)
Sure. They can work fine together. Make sure you install 2000 first.
December 1, 2008 at 4:31 am
Please don't use polls unless you are actually posting a poll.
What's the question?
December 1, 2008 at 4:28 am
Keep a copy of the old proc, under a different name, and you can run them both to check.
I've often used Excel to compare two resultsets. Put each resultset...
December 1, 2008 at 4:28 am
When you say "update is not working", what exactly do you mean?
Throws an error?
Runs forever?
Updates no rows?
Something else?
December 1, 2008 at 4:25 am
On the first execution, the statement has to be complied and optimised. The optimiser will optimise all of the queries in the proc, regardless of whether or not they can...
December 1, 2008 at 4:24 am
Tom Brown (12/1/2008)
December 1, 2008 at 4:21 am
Why the app lock? What's that for, and could that be the cause? If lots of other procs are alse using applock, it could take a while for this one...
December 1, 2008 at 4:18 am
If you run the contents of the proc in query analyser, of the insert, update and select, which one is the slowest?
December 1, 2008 at 4:08 am
You could use the SSIS transfer jobs task (on the 2005 server) to pull the jobs over.
December 1, 2008 at 4:06 am
azlisyam79 (12/1/2008)
3. Daily backup, dump to tape
What about transaction log backups? If you're not doing any, there's your problem right there.
If you're not doing log backups, take a look through...
December 1, 2008 at 4:02 am
Depends what you're doing.
Usually derived tables are less intensive because there's no interim storage and no need to insert stuff somewhere and then query it out. If you're doing...
December 1, 2008 at 4:00 am
rbarryyoung (11/30/2008)
You could just give us free query access to the database.😀
There's an idea. We promise we won't break anything....
(I need an angel with halo smilie - innocence)
Steve: Are you...
November 30, 2008 at 11:48 pm
Tom Brown (11/28/2008)
November 30, 2008 at 11:40 pm
jeff.kaden (11/19/2008)
Could anyone guide me through Microsoft trainers or some instructors? I'm looking for information about the best trainer available.
Knowing where you are based in the world would be useful.
November 30, 2008 at 11:34 pm
rbarryyoung (11/30/2008)
I can assure you that some of us are posting at 3:30am. :laugh:
Yup. I was posting at 1am the other day, though I doubt anyone would have noticed...
November 30, 2008 at 11:32 pm
Viewing 15 posts - 42,766 through 42,780 (of 49,571 total)