We have an SQL server with about 40 different (about 1-5GB each) databases. The server is an 8 core 2.3G CPU …
sql-server sql-server-2005 cpu-usage sql-server-performanceWe have a small (for now) Asp.Net MVC 5 website on a dedicated VPS. When I go to the server …
asp.net performance sql-server-2012 cpu-usage sql-server-performanceI have a table called Transaction_tbl with more than 400 000 records in it. This is the table structure: CREATE TABLE […
sql-server sql-server-2008 stored-procedures sql-server-performanceI've never really understood the difference between these two indexes, can someone please explain what the difference is (performance-wise, how …
sql sql-server tsql database-indexes sql-server-performanceWe have a new sp getting released and during testing we found that when it runs its blocking other OLTP …
sql-server database sql-server-performanceHow much fragmentation is bad? How low of scan density is too low? How low does scan density is bad? …
sql-server sql-server-2000 indexing fragmentation sql-server-performanceAlthough a couple of questions were already posted in SO about the difference between Over Partition By and Group By, …
sql-server group-by window-functions sql-server-performance