Viewing 15 posts - 42,766 through 42,780 (of 49,566 total)
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
Mh (11/30/2008)
In addition to running the below queries:Do we also need to configure the /3GB switch in the boot.ini file?
When do we enable AWE? before running these queries?
No idea....
November 30, 2008 at 11:23 pm
In general, triggers should not start jobs, send email, launch applications or anything of the sort. A trigger should be doing small data verifications or changes, nothing more.
November 30, 2008 at 2:26 pm
Lynn Pettis (11/30/2008)
Yea, that works, that's my story, and I'm sticking to it.
😀
November 30, 2008 at 12:10 pm
As I mentioned over at SQLTeam, you may want to give CSS a shout. If no one's answering it's most likely because they don't know.
November 30, 2008 at 12:09 pm
Ok, so you need the users, with their database and server roles and with the permissions that they have directly on database objects.
One database or all?
November 30, 2008 at 11:48 am
Viewing 15 posts - 42,766 through 42,780 (of 49,566 total)