Viewing 15 posts - 42,751 through 42,765 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 4:24 am
Tom Brown (12/1/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2008 at 4:08 am
You could use the SSIS transfer jobs task (on the 2005 server) to pull the jobs over.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2008 at 11:48 pm
Tom Brown (11/28/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 30, 2008 at 12:09 pm
Viewing 15 posts - 42,751 through 42,765 (of 49,552 total)