Thanks,

Basically I wanted to run a ad hoc query which contains encryption key for accessing the database objects.

As my database objects are encrypted, I don't have access...

Thanks Lowell,

Our company is a product development company, we have a product through which online assessments can be conducted. We have two kinds of hosting.

We will distribute our application...

Thanks Paul,

In our database there are around 3,000 procedures and as we are deploying our application in multiple location, we need some sort of encryption for our...

Thanks Jeff.

Through DBCC ShowContig I checked the logical fragmentation and also using DMV query to measure the index fragmentation.

Database load is around 150 to 200 users.

As I see there are no...

this is the time and io statistics

Table 'ScheduleUser'. Scan count 0, logical reads 3, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead...

Hi,

This is the update statement

----------------------

UPDATE results SET score = T.Score,

attempted = 1,

AnswerCorrect = T.Answercorrect

FROM results R with(nolock) ...

Retention period will be 2 months.

Selection of records is little bit slower, but this can be overcome by having one denormalized table.

and here is the execution plan

One more thing I would like to add...

There will be one new test for one week.

Tests will be conducted throughout the week.

Thanks Gail,

Ours is a online assessment application where students will take tests everyday.

Suppose there are 100 questions in one test, then 100 records will get inserted to the mentioned table.

Table...

Thanks Gail,

There are couple of indexes which will boost query performance.

But daily there will be upto two million records insertion. This will become huge in couple of weeks.

Thank you all for your feedback....

I will work on it with your suggestions keeping in mind....

Thanks Gail...

Gail I have one more query for you...

I have created a non clustered index for these to columns... will there be any impact on the size of the column... because...

Thanks for the reply....

I will update on this once it is done...