Browse by Tags
All Tags »
SQL (RSS)
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...
I thought everyone who wants to know how to put the windows events or IIS Logs to SQL already know about it. But for my amazement it is not the case. Quick search on the web did not turned up a short tutorial. So how to move my window events to SQL? Here
Read More...
There are many different ways you can partition a cube. Here I am talking about – how you can use C# to partition a cube from a DTS package? Using Microsoft.AnalysisServices Object API, you can travel the whole Hierarchy of objects and completely administer
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...
Often it happens, that we want to play with a column value of a table. Not knowing the ramification of the column value, we have to resort to the back breaking manual process of finding the dependency on the column. Using the management studio, get the
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...
I seen couple of articles talking about OUTPUT Clause of SQL 2005, but no one is warning the side affect of it on the scope_Identity() function. Let me explain with an example: You have a Table T1, and would like to save the auditing data from T1 to T2.
Read More...
