Advertisements

Archive

Archive for the ‘SQL’ Category

Understand Response Time vs. Total Time in SQL

June 8, 2012 Leave a comment

Response time is the time it takes for a query to return the first record. Total time is the time it takes for the query to return all records. For an interactive application, response time is important because it is the perceived time for the user to receive visual affirmation that a query is being processed. For a batch application, total time reflects the overall throughput. You have to determine what the performance criteria are for your application and queries, and then design accordingly.

Read more…

Advertisements

SQL Azure Database Take Offline

As everyone knows that database administrator can take SQL Server Database offline for maintenance purpose with following command Read more…

SQL+MDX in one Apartment (Hybrid Query).

While replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means. Read more…
%d bloggers like this: