Viewing 15 posts - 106 through 120 (of 420 total)
Next time you get one of these it may speed things along if you post the deadlock graph. There are several classes of deadlocks and nobody can determine the...
January 5, 2015 at 4:27 pm
Ok, so for starters, you keep saying BCP and this is not BCP. BCP is a separate cmdline program. You're using Bulk Insert in tsql. Just wanted...
January 5, 2015 at 4:21 pm
They are absolutely correct. Typically a version is kept as a gold standard in a code vault of some kind and then everything else compared with that.
There are free...
January 5, 2015 at 4:16 pm
Some of the issues I've seen with Dist latency revolve around some of these issues:
1. The DB isn't indexed properly so consider adding indexes to a couple of the tables....
January 5, 2015 at 4:07 pm
And to follow-up on Grant and Gail, I've seen plenty of times when DBTA doesn't cleanup after itself very well. So whenever you use it always search for hypothetical...
January 5, 2015 at 3:59 pm
That's why I suspected it may be a relay issue.
Talk to your exchange guy.
January 5, 2015 at 11:54 am
Quite often in companies, they deny servers the ability of servers to use exchange as a relay server. You have to ask your email admin to add your sql...
January 5, 2015 at 11:18 am
Are the mail XPs installed and the acct has perms to run them?
January 5, 2015 at 10:37 am
Are there any msgs in the Agent Error Log?
January 5, 2015 at 8:22 am
I'm curious as to why you expected it to be 4GB. What were you basing that on?
However, assuming you're close to accurate in your assumption, like a couple of...
January 5, 2015 at 8:18 am
No, you can't keep someone from defining their app name in the conn string, but you can also limit it by hostname so it could be a combination of appname...
January 2, 2015 at 4:48 pm
I've got a great reindex routine I've written and it's free. Tons of functionality, and very easy to get up and running.
Just click the little green guy below.
January 2, 2015 at 4:38 pm
Have you solved this issue yet? I've seen something like this before and it was a driver issue.
January 2, 2015 at 4:36 pm
So looking at this I see you're doing more scans than seeks on your PK. That would make me either revisit my cluster or some of my queries.
January 2, 2015 at 4:32 pm
Yeah, this is pure param sniffing. You're caching and recompiling when you do the reindex.
There are ways to even out the perf. Just lookup parameter sniffing online and...
January 2, 2015 at 4:27 pm
Viewing 15 posts - 106 through 120 (of 420 total)