I could only think you need to add error handling in your code

Example: you can think of following code to handle the duplicate key issue

BEGIN TRY

CREATE UNIQUE CLUSTERED INDEX ix_tblname...

You have to include MAXERRORS option in your BULK INSERT statement.

The default MAXERRORS value is 10.

Since you have only one error, it was not caught by the TRY...

Yes, I know that column included in the select query also consider by Query Optimizer.

however, if you see the second query's excution plan it uses the non clustered index...

Yes, the answer is "Ann". But when you say most of the time we would get “Ann” since the clustered index is created on “first name”.

Why can’t we say...

Thank you, By the way can you tell me which edition (x86, 64-bit and 64-bitIA ) I should buy ?

my system configuration is

x64 Based PC

Intel Core i5 CPU M...

So, You mean there is only one developer version that can be installed irrespective of 34 or 64 bit system.

Try this !!

SELECT CASE WHEN DAY(DATEADD(D,1,GETDATE()))=1 THEN 'MONTH END' ELSE 'NOT MONTH END' END AS PERIOD

Hope this helps.

good basic question.

Declare @strSql varchar(2000)

Set @strSql = ''

Set @strSql = @strSql + 'Create table #tmp (id int)'

Set @strSql = @strSql + 'Insert into #tmp(id) values (1) Select * from...

Grant Fritchey

usually we use maxdop option to optimize the performance.

what will best solution without changing the maxdop option if we get this deadlock error.

thanks !!

I would say don't disclose employee Pay information whilst employees must know the financial shape of the company

my suggestion will be sum all employees annual pay and publish

Max

Returns the maximum value in the expression.

Hi,

I don't think you can disable the idnex.

instead you can drop and re create it.

If your table contains huge no of records with clustered index created

then re creating index...

Hi

You mean the Storage Engine pulls the data and send it to Query Processor

then Query Processor will operate on the data to form the result (i.e) Group by...

create table #tmp(iden int identity(1,2) , id int, value varchar(15))

create table #tmp1(iden int identity(2,2) , id int, value varchar(15))

insert into #tmp values( 1 , 'a')

insert into #tmp values( 2 ,...