A study conducted by MSCOM ops team found 1 GB of data took 110 Minute to push and 12.5 minutes to Pull across the continents. Furthermore SQL 2008 with Windows Server 2008 made a huge difference over SQL 2005 and Windows Server 2003. Push subscription
Read More...
These queries can save your life. Query to find the query using the most CPU: select highest_cpu_queries . plan_handle , highest_cpu_queries . total_worker_time , q . dbid , q . objectid , q . number , q . encrypted , q . [text] from ( select top 10 qs
Read More...
We had an application which was not performing fast enough for our satisfaction. The application updates various tables with millions of records. We tweaked few things in our SQL and suddenly the speed of application improved to our target level. All
Read More...
