Viewing 15 posts - 931 through 945 (of 9,399 total)
Glad you got it figured out. Thanks for posting back.
September 18, 2017 at 9:06 am
Do you have a SET NOCOUNT ON in your stored procedure like Lowell and I suggested? I know it can interfere with some ODBC calls. It won't interfere with @@ROWCOUNT...
September 18, 2017 at 8:29 am
September 18, 2017 at 7:26 am
In addition to the execution plans, I'd also use SET STATISTICS IO ON to take a look at the total number of reads from both tables.
September 18, 2017 at 6:06 am
Welcome to SSC.
Does your procedure return more than one result set? Meaning, if you execute your procedure from SSMS, do you see just one results set in the...
September 18, 2017 at 6:03 am
September 18, 2017 at 5:36 am
September 18, 2017 at 5:18 am
When you require encrypted connections, you don't have to install anything on the client. However, take a look at your network traffic when it isn't turned on. Everything is plain...
September 17, 2017 at 5:29 pm
Great question. I remember looking into EE on SQL 2008. I let it run for 20 minutes and turned it off. I then tried to read in the file I...
September 17, 2017 at 5:17 pm
I had to look it up to see if one had been added I didn't know about.
September 17, 2017 at 5:08 pm
What a great question! My sincere compliments on coming up with a cleaver scenario. The real question, Steve, is what do you do at work to warrant such a ratio?...
September 17, 2017 at 5:06 pm
It also depends on the culture you work in - your environment. In a mature environment, people want to get the job done and they want things to work well. ...
September 17, 2017 at 4:56 pm
September 17, 2017 at 4:47 pm
Viewing 15 posts - 931 through 945 (of 9,399 total)