Archive for September 16th, 2013
Rolls-Royce Wraith – the making of the launch film
Montag, September 16th, 2013Fujitsu PRIMERGY RX300 S8 – with Intel Xeon E5-2600 v2 processor up to 12 cores
Montag, September 16th, 2013
The Fujitsu PRIMERGY RX300 S8 Server is a 2U dual socket rack server optimized for all types of business applications by focusing on versatility and scalability that supports up to 16 harddisk drives up to 7 PCIe Gen 3 cards and up to 1536 GB RAM
Microsoft SQL Server – improve SQL Server performance with a simple query
Montag, September 16th, 2013
Run this query on a Microsoft SQL Server 2005 or later and it will list indexes that you could create to improve the query performance of your database based on the workload of the server since the SQL service last restarted
SELECT ‚CREATE INDEX IX_Auto_‘ +
CONVERT(varchar(max), MID.index_handle) +
‚ ON ‚ +
[statement] +
‚ (‚ +
COALESCE(equality_columns + ‚, ‚ + inequality_columns, equality_columns, inequality_columns) +
‚)‘ +
ISNULL(‚ INCLUDE (‚ + included_columns + ‚)‘, “) AS create_statement,
CONVERT(int, avg_total_user_cost * user_seeks * avg_user_impact) AS potential_saving,
[statement] AS table_name,
equality_columns,
inequality_columns,
included_columns,
last_user_seek,
avg_total_user_cost,
user_seeks,
avg_user_impact
FROM sys.dm_db_missing_index_details MID
JOIN sys.dm_db_missing_index_groups MIG ON MIG.index_handle = MID.index_handle
JOIN sys.dm_db_missing_index_group_stats MIGS on MIGS.group_handle = MIG.index_group_handle
ORDER BY avg_total_user_cost * user_seeks * avg_user_impact DESC
Italy Isola del Giglio – online webcam
Montag, September 16th, 2013
