Comments by brianriggan

brianriggan 15-Dec-14 12:37pm View

It does not always return 0 rows.. I was just using that as an example because usually slowness comes from the number of rows returned.. in this case the slowness is being caused by something else.

brianriggan 15-Dec-14 11:51am View

The table is indexed as it should be.
About 300,000...
There are not partitions this is a subject I am not very familiar with.. We do not have a "real" dba so I think this might be a configuration issue that has not been addressed. Also the number of fields are a requirement in this case... Another part of this puzzle.. The query is a parameterized string the query executes sub second very fast in SQL management studio but takes a full second to execute the same query using a data reader in C#.

brianriggan 15-Dec-14 11:46am View

The problem is that I do need all of the columns, I have slimmed down the result set as much as possible the original author was using SELECT * I am only getting what is needed... I just need a large number of rows. Is there a setting in SQL server so that I could increase the memory used for a query or something?

brianriggan 18-Nov-14 16:49pm View

Cannot view this at work will try and look tonight sorry.

brianriggan 18-Nov-14 16:38pm View

You know I have not ever actually done so. I would assume you could post a link to one of the free image sharing sites might want to get an admins input on that though. I have been a creeper for years but rarely ever posted.

brianriggan 18-Nov-14 16:22pm View

Unplug the machine take it outside and throw it on the ground. Just kidding can you post a screenshot of the error? (Referring to posting a screenshot of whatever is telling you that it is corrupted.)

brianriggan 18-Nov-14 15:51pm View

Yes not the entire thing just what you suspect is causing the error.

brianriggan 18-Nov-14 15:30pm View

I do not believe that Windows 7 has smart screen so that is not it. I think that tgrt was correct in his assertion that it is a Malware/Antivirus issue. Try enabling logging when you run the install then examining/posting the error from the log file.

brianriggan 18-Nov-14 15:16pm View

Probably not the issue I am thinking of but I had problems when "Smart Screen" was enabled but that was on a Windows 8.1 machine.

brianriggan 18-Nov-14 14:40pm View

I agree this is similar to what I was seeing running windows 8.1 with the "smart shield" enabled.

brianriggan 18-Nov-14 14:37pm View

What OS are you running?

Comments by brianriggan (Top 11 by date)