ColumnStore Index Quick view and Performance test (Video)

SQL Server 2012 introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. This new index, combined with enhanced query optimization and execution features, improves data warehouse query performance by hundreds to thousands of times in some cases, and can routinely give a tenfold speedup for a…


Profiler Replicator, A SQL Server Performance Testing Software based on SQL Profiler

I’ve developed a small application that will help you test the performance of you SQL engine. the application simply retrieve your Queries from a Pre-set Profiler table and start replicate this in multithreading mode with you set configuration to brute the destination database and you can get out of it of simple Log with all…

2

List Connections and Users connected to Lync Registrar Pool

The following script could be copied to %windir%/system32 as connections.ps1 in order to run it from Lync powershell directly.   It will list all the number of connectios to the registrar pool; i have added Listing all user aliases connected to Lync within the main Function. ################################################################################################## Connections.ps1## Program to pull Lync connection information.  # This…

9

What do you Know about the SQL Server Data pages ?

SQL Server page is 8K so remember when you format your hard disk. Create it in a 64K clusters for the best performance. Let’s no more about the SQL Page ·         96 Bytes for the page Header ·         8096 for the page rows with a limits 8060 bytes Only for rows. ·         2 bytes in…