0
votes
1answer
145 views

SQL express 08 R2 running on Windows datacenter server 08 optimization

I am running SQL server express R2 on Win Server Data Center 08 (basically Ec2 micro instance). My total allowed memory is 613 MB. When I launched the instance for the first time my total consumed ...
1
vote
1answer
144 views

how to make a server that handles 1000 clients [closed]

I am looking for server software to handle data for thousands of clients (internal company employees). This server should be multi-threaded to handle all the clients with good client overhead ...
0
votes
1answer
78 views

Cost of Parameterization in SQL Server 2008

Does Anybody know absolute or relative cost of forzed parameterization in SQL Server 2008?
1
vote
1answer
328 views

LEFT JOIN Server Performance optimization

I have a query that I want to execute that fastest possible. Here it is: select d.InvoiceDetailId,a.Fee,a.FeeTax from InvoiceDetail d LEFT JOIN InvoiceDetail a on a.AdjustDetailId = ...
0
votes
1answer
507 views

What is star query optimization?

I found in a features table for SQL Server 2005 a row named "Star query optimization" but it is not explained anywhere. Could this be a feature that optimizes a query like : SELECT * FROM Table
2
votes
3answers
614 views

What optimizations can be performed on SQL Server with SAN?

This question is a bit general since I am not exposed to SAN (Storage Area Network). Are there any optimizations or configuration changes that can be performed with SAN to improve SQL Server ...
3
votes
6answers
2k views

Method for finding unnecessary indexes of an operational SQL Server database?

Besides wasting space on the database, unnecessary indexes on SQL Server can slow down insert and update operations. Developers who lack experience in database principles sometimes tend to create ...
9
votes
1answer
887 views

How can I tell when it is time to defrag my SQLServer database?

What is the best practice for measuring SQLServer database fragmentation/performance rolloff and determining when to defrag a SQLServer database table? I'm most interested in learning what the useful ...