What is sparse columns of sql server 2008?
No Answer is Posted For this Question
Be the First to Post Answer
What is a trace frag? Where do we use it?
How do you read transaction logs
Tell me what is de-normalization and what are some of the examples of it?
What are the differences between decimal and float in ms sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
How to implement service broker?
Why is sql server log file full?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is statement level trigger?
* CREATE TABLE [dbo].[t_Colors]([ColorId] [int] NOT NULL,[ColorName] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ColorDesc] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,[ColorIndex] [int] NULL) ON [PRIMARY] GO * insert into [t_Colors] values(101,'Red','',1) insert into [t_Colors] values(101,'Red1','',2) insert into [t_Colors] values(102,'Blue','',1) insert into [t_Colors] values(102,'Blue1','',2) insert into [t_Colors] values(102,'Blue2','',3) * In this table i need to delete DELETE FROM t_Colors WHERE ColorIndex=1 AND ColorId=102 After delete above condition i need to update the ColorIndex set to 1 for Blue1[ColorName] and 2 for Blue2[ColorName] select * from [t_Colors] Note:- how can i get updates the ColorIndex values after delete. for example we need to update Blue1 ColorIndex set to 1 and Blue2 ColorIndex set to 2
Does index speed up select statements?
Detail about the hardware which is supported by SQL server?