Archive for September 30th, 2013
Microsoft Windows 8.1 – with the return of the Start button
Montag, September 30th, 2013Lenovo IdeaCentre B750 All-in-One Desktop – is the world’s first Full HD 2560×1080 21:9 super-widescreen frameless display
Montag, September 30th, 2013
Lenovo IdeaCentre B750 is an all-in-one PC with a 29” screen and a 2.1 surround audio system, as well as a broad range of entertainment functions. The display has a smooth glass front, focusing attention on the screen. The speakers are concealed under a subtle metal mesh so as not to detract from the overall impression. The computer rests safely on an aluminium stand and blends seamlessly with modern living spaces
Microsoft SQL Server – create stored procedure ‚DefragmentIndexes‘ in master database
Montag, September 30th, 2013
When a query is executed on a database, indexes are used to physically locate the data on disk. Due to frequent insert, update and delete statements this data can become fragmented. This is a serious performance issue. To mitigate this schedeule this script in a SQL Agent Job to frequently defragment you indexes. Create stored procedure DefragmentIndexes in master database. This stored procedure defragments the indexes in your database
