Thanks for quick help !!

Thank you for valuable suggestions, it worked !!

There is a separate "Website" table which has websiteid as a primary key and identity column.

and Article table has articleid as a primary key and identity column and in...

Stories table is having 1,00,000 records which is used by 50+ sites and these records are increasing everyday.

What if I add a new column "IsArchived" in Stories table and run...

No, I will scan for common conditions just once:

1. In main procedure I will store below query result in temp table/variable,

You will see that I am just selecting StoryID...

I am not trying to reduce the number of procedures, but trying to avoid repeatative scanning of Story table for common conditions. As I said there are 4 common conditions...

Hi,

In Windows Task Manager sqlservr.exe process showing 1.6 GB memory usage. Not sure this is what I need to check ?

Hi,

We are using asp.net and all our database related codes are enclosed inside using() which takes care of closing/disposing the connections after operation is done:

using (SqlConnection connection = new SqlConnection(connectionString))

{

...

Hi,

I used exec dbo.sp_WhoIsActive @get_plans = 1, @get_additional_info = 1 and most of the time it is showing below procedure as Blocking Procedure:

SELECT top 20 StoryID, SectionID,...

Thanks, it worked! I am not sure about query performance, will check with actual database or may be will try other alternative as per your suggestion.

How can I order first by category names and then by item names? I tried to use order by in following query:

SELECT ItemName

FROM (SELECT *

...

Great !! pretty simple and clean approach!

Can I alphabetically sort the result by category name first and then alphabetically sort item names?

Thanks for your help.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Category](

[CategoryID] [int] IDENTITY(1,1) NOT NULL,

[CategoryName] [varchar](50) NULL,

CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED

(

[CategoryID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

Below is the result I want:

CategoryName1

ItemName1

ItemName2

ItemName3

CategoryName2

ItemName4

ItemName5

CategoryName3

.

.

.

and so on

I want to dynamically load both category names and their respective item names from these 2 tables into a dropdownlist.

this is table structure:

Category: CategoryID, CategoryName

Item: ItemID, CategoryID, ItemName

Now, I want to display item names in drop-down along with category name:

CategoryName1

ItemName1

ItemName2

ItemName3

CategoryName2

ItemName4

ItemName5

CategoryName3

.

.

.

and so on