Hi Dilip,

don't worry. Suppose if you have 4 columns col1, col2, col3 & cols & you use:

order by col1, col2, col3, col4

then sql server first orders by col1,

then col2

then col3

then...

Please check the below points too:

1. what is you DB server time zone & web server time zone

2. Are you inserting datetime variable or a varchar variable data

3. As you...

you can also use CLR code & use multi threading to start several parallel process.

If your view contains data from several tables & you have to use that view in several queries, then It is always better to create views.

Views does not have any...

Hi Karthik,

I think you should convert 'Mon Sep 17 00:00:00 CEST 2012' & 'Sat Feb 09 17:16:18 IST 2013' to datetime format string before inserting data into your table.

Because...

thanks John,

this is really a very good & simple approach to catch all the search patterns. I didn't thought about such logging table. I will definitely follow this approach.

I more...

Thank you Fritchey, Gail,

Now, I am much satisfied.

Finally, this is the conclusion that I will check those columns which takes part in the query mostly & which column(s) are...

yes, this is clear now.

Thank you for this good explanation.

I am afraid that I again asking a question. But before asking again, I have to explain my case.

record_cat is...

Once again, I have a situation where my way is again blocked.

As I said earlier in this post that I have to implement indexing on a group of tables. Before...

I was just reading the article:

http://www.sql-server-performance.com/2007/t-sql-where/2/[/url]

There is a recommendation given below:

"If you have a WHERE clause that includes expressions connected by two or more AND operators, SQL Server will evaluate...

thanks, it sounds great. 🙂

but now I am afraid because now I will have to ENJOY my weekend in the office again. 🙁 🙁

again, thanks a ton mate.

this time,...

Hi Gail,

I read all the articles listed in your link. This is really very good information.

All the requirement & best practice are good. But I have still a question in...

Hi Gail,

I have changed my one stored procedure. As you have the code block which I posted. Now that block will look like this:

IF @inbCityID IS NOT NULL AND @inbCityID...

Gail, thanks for the link,

Hi Fritchey,

We have made the SQL like this,

IF @inbCityID IS NOT NULL AND @inbCityID > 0

BEGIN

SET @SqlCondition = @SqlCondition + ' AND vaa.CityID = ' + CONVERT(VARCHAR(50), @inbCityID);

END

(this is only...