Fastest way to find row count of all tables in SQL

Below is the syntax for the query which does exactly what the title suggests.

SELECT  T.NAME AS [TABLE NAME],I.ROWS AS [ROWCOUNT] 

FROM SYS.TABLES AS T INNER JOIN SYS.SYSINDEXES AS I 

ON T.OBJECT_ID = I.ID AND I.INDID < 2 

ORDER BY I.ROWS DESC 

Read more »

.NET: Asynchronous Callback Approach in ADO.NET

Note: Thank you for visiting my blog. However, this blog is not maintained actively anymore. This post is now also in my new blog. Feel free to leave a comment there.

I am studying Professional ASP.NET 4 in C# and VB book from Wrox Publication. It is a great book with really easy-to-understand basic examples. As I'm a novice in ASP.NET/.NET Framework, it really helped me a lot in understanding the technology. Wrox also lets you download the codes used in the examples in the books. Anyone interested can download the same from this link: Code for Professional ASP.NET 4 in C# and VB.

But sometimes, I found some mistakes in the examples, provided in the book. I tried the same code in my machine, but I was unable to produce the desired result. So  I'm going to discuss on a similar mistake I've found in the book recently and also going to discuss the workaround.

We're going to discuss on Asynchronous Callback Approach in ADO.NET. Before we jump straight  into the topic first let me explain what is Asynchronous Processing in ADO.NET.

Introduction

In general, in ADO.NET, each command is executed sequentially, i.e. code waits for the previous command to be completed before it starts executing the next command.

Asynchronous approach lets you do the processing in a parallel manner. Using this approach two sql commands can be executed in parallel using the same connection.This comes real handy when you are dealing with multiple data sources, like you have two GridView controls in your page, one for displaying employee's personal details, another for displaying the employee's payment change history. Apart from processing the command executions in parallel it also lets you perform other tasks(those are not dependent on the output of command execution) without completing the command execution.

Read more »

SQL : CSV To Table using xml

Note: Thank you for visiting my blog. However, this blog is not maintained actively anymore. This post is now also in my new blog. Feel free to leave a comment there.

In this article I'm going to discuss about how to convert a comma separated string to a table to enable it for set based operation. 

Lets say we've a table which has the definition like this :

Create Table Employee 
(     
    EmpId Int,     
    EmployeeName varchar(100) 
)

Problem Statement

You need to retrieve  Employee Name based on EmpId provided. Now it is easier to retrieve the data when you have the EmpIds separately and the same can be used as below :

Select * from Employee where EmpId in (10,21,32,43,54,74,78,47,56,12,68)

The above query treats every EmpId separately. Now what if you get all the EmpIds in a single comma separated string like : '10,21,32,43,54,74,78,47,56,12,68,'. In that case you can not write query as below:

Select * from Employee where EmpId in ('10,21,32,43,54,74,78,47,56,12,68,')

The above query will not treat the EmpIds separately, but as a single csv string as a result this query will produce an erroneous result or may not parsed at all.

Read more »