Viewing 15 posts - 1,711 through 1,725 (of 5,843 total)
bantrim (1/12/2015)
Jeff Moden (1/11/2015)
January 12, 2015 at 12:40 pm
Could also be long-running transactions, snapshot or RCSI isolation level use, many concurrent queries doing large hashs and/or sorts, suboptimal indexing, crappy queries, huge/bad cursors, etc.
January 12, 2015 at 10:25 am
bantrim (1/11/2015)
TheSQLGuru (1/11/2015)
January 12, 2015 at 6:22 am
bantrim (1/11/2015)
Jeff Moden (1/11/2015)
I'm thinking that a UNIQUE NIX on the ID and Hash (and that combination should be unique because the ID is unique) might...
January 12, 2015 at 6:15 am
Your statement of the problem, even with a second posting, isn't making sense to me, especially given the data you have provided. I/we need one more thing: expected...
January 12, 2015 at 6:11 am
Jeff Moden (1/11/2015)
Or just make them run better. 😉 Then there won't be a problem that you have to throttle or manage.
Not true Jeff. You can absolutely receive...
January 12, 2015 at 6:04 am
Markus (1/12/2015)
January 12, 2015 at 6:02 am
ghurty (1/11/2015)
Is there a way to throttle or limit the amount of sql requests either by IP address or username?Thank you
Depending on what they are doing you could perhaps store...
January 11, 2015 at 3:21 pm
Most of my healthcare work has been directly for services providers or insurers, although I have worked directly with Centricity and a few others, especially on data movement stuff. ...
January 11, 2015 at 3:15 pm
This is the dreaded IS NULL OR scenario (with paging thrown in for good measure). Best solution BY FAR is dynamic SQL. It could also possibly benefit from...
January 11, 2015 at 9:52 am
1) you REALLY need to read Thomas Kejser's blog post on hashing in SQL Server: http://kejser.org/exploring-hash-functions-in-sql-server/. I believe he has others.
2) I have used what you are doing for...
January 11, 2015 at 9:42 am
Why in the world are you worried about 10GB on a 170GB file?!? Leave it and move on - I GUARANTEE you that you have MANY more things to...
January 11, 2015 at 9:31 am
Please start a new thread. This one is 4 years old.
January 9, 2015 at 1:53 pm
1) The reason for it is performance
2) Did you make the trace flag a startup parameter?
January 9, 2015 at 6:55 am
Search the web for Glenn Berry SQL Server hardware and you will get a number of relevant links, including his free eBook: http://download.red-gate.com/ebooks/SQL/sql-server-hardware-ebook.pdf
January 9, 2015 at 6:52 am
Viewing 15 posts - 1,711 through 1,725 (of 5,843 total)