Viewing 15 posts - 6,286 through 6,300 (of 49,571 total)
It's the stored proc.
Not uncommon for a dev server not to show performance issues that prod does. Dev typically has tiny data sets and a couple of users at most....
April 1, 2015 at 3:37 am
A timeout means that the procedure is running for longer than the application is willing to wait. You'll need to analyse the proc, identify the cause of the poor performance...
April 1, 2015 at 2:50 am
If that was my system, I'd start by looking at the execution plan and seeing if the index is optimal. Good chance it isn't.
March 31, 2015 at 1:07 pm
sqlfriends (3/30/2015)
If blocking is not the issue, what could it be?
Where did I say that blocking is not the issue?
It's lock-related waits, that's blocking by definition.
I said "the blocking process...
March 31, 2015 at 10:53 am
There isn't a threshold. A table which never gets updated could have stats 5 years old which are still good. A table which gets updated thousands of times a second...
March 31, 2015 at 7:59 am
stephen.long.1 (3/31/2015)
March 31, 2015 at 7:55 am
If you can figure out a computed column that will always be unique, using your requirements and probably the primary key, you can put a unique index on that
March 31, 2015 at 7:52 am
Brandie Tarvin (3/31/2015)
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
Dare we ask which poster?
I'm...
March 31, 2015 at 7:51 am
Yet Another DBA (3/31/2015)
The "Most of those I have worked with " is based on experience and not some slapdash generalisation
Fair enough. 🙂
I think the majority of people I've worked...
March 31, 2015 at 6:41 am
Kris Gruttemeyer (3/30/2015)
Database 'Utilities' running the upgrade step from version 781 to...
March 31, 2015 at 5:43 am
Yet Another DBA (3/31/2015)
March 31, 2015 at 5:28 am
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Not efficient as it prevents index seeks, not that a text column can have indexes, but I don't like teaching bad options.
Exactly my point: a bad option is...
March 31, 2015 at 5:20 am
DBA From The Cold (3/31/2015)
I don't think OR is supported in filtered indexes WHERE clause.
That's my recollection as well. Filtered indexes are nice in places, but they're still very...
March 31, 2015 at 4:35 am
spaghettidba (3/31/2015)
GilaMonster (3/31/2015)
Nice attitude...if you had type this in the first place, then i would not have shouted... hehe
Thank you for your First informative reply.
You're far too kind. I have...
March 31, 2015 at 4:34 am
You can detach/attach or you can use ALTER DATABASE ... MODIFY and then change the names of the files in the file system, same process as you'd use to move...
March 31, 2015 at 4:27 am
Viewing 15 posts - 6,286 through 6,300 (of 49,571 total)