Viewing 15 posts - 7,516 through 7,530 (of 8,416 total)
scziege (7/2/2009)
July 2, 2009 at 9:21 pm
scziege (7/2/2009)
The stored procedure calls a user-defined function which generates the code. But this is notthe reason why the performance is so bad.
I would encourage you to test that. ...
July 2, 2009 at 9:01 pm
Nice job Abhay!
July 1, 2009 at 3:14 am
SQLSlammer (7/1/2009)
Dave Ballantyne, well if you're not Scottish and you didn't work in Hemel Hempsted then it's definitely not you 🙂
Hemel Hempstead has one of the most amazing roundabouts I...
July 1, 2009 at 3:11 am
SQL Noob (6/30/2009)
June 30, 2009 at 7:48 pm
Gianluca Sartori (6/30/2009)
Could "Install SAP" be an answer?:-D
I dare you 🙂
June 30, 2009 at 3:25 pm
Bruce W Cassidy (6/30/2009)
[font="Verdana"]Welcome to the department of redundancy department.[/font]
Welcome to the department of redundancy department.
June 30, 2009 at 3:19 pm
Gianluca Sartori (6/30/2009)
Crystal ball needed here as well...
The OP is using Navision. Case closed. 😎
June 30, 2009 at 3:17 pm
I used to work at a place where Navision was used.
It always sucked from a performance point of view - and it wasn't helped by their database schema, which was,...
June 30, 2009 at 3:16 pm
Gaby Abed (6/30/2009)
If you've ever read Restaurant at the End of the Universe, you may remember this section when grammar and time travel collide.
I willan already on-reading that yesterday again...
June 30, 2009 at 3:01 pm
Michael Valentine Jones (6/30/2009)
June 30, 2009 at 2:49 pm
As tempting as the AWE 2K topic is, and as much as I dislike the /3GB switch, I must get some sleep!
Night all. 🙂
June 30, 2009 at 9:28 am
Jeff Moden (6/30/2009)
Does anyone know if Master.dbo.spt_Values has been deprecated?
Oh. I always thought of it as 'undocumented' anyway...? :unsure:
June 30, 2009 at 9:24 am
Michael Valentine Jones (6/30/2009)
OK, I understand now, but it might be worthwhile to include a comment about the purpose in code like that. 🙂
Heh. It would be better never...
June 30, 2009 at 9:22 am
Lynn Pettis (6/30/2009)
If all three instances try to go to max memory levels, then yes it is more than the physical memory in the server.
Good post. Just quoted this...
June 30, 2009 at 9:03 am
Viewing 15 posts - 7,516 through 7,530 (of 8,416 total)