Paul nice example

but if the table is heavy transactional table and we have indexed view on that and then clustered index on it.

Will it improve the performance?

which...

jsb12

can you please tell me exactly , at what time full backup is taken and what time log backup

and also at what time you are planning to restore...

Well i dont think it will restore wrong backup if copy...

Goto properties of job >> general tab>> select owner = 'Sa' or the login you want to select

Do one thing , open job ( right click and open) and set owner's_name = login which you are using for executing that Sp in mgmt studio , if it...

If this happens, put a ID int identity column and set composite key on job_id and ID.

then you can go for Clus. Index

there are two things :

first since you have composite key , it means you can have clustered index on it

and second thing i guess , we can...

HOw to set this setting ?

if i set this user with...

DECLARE @sql varchar(max), @Database1 varchar(300)

set @Database1 = 'tempdb'

SET @sql='

USE '+@Database1+';

IF EXISTS (SELECT 1 FROM SYS.VIEWS WHERE NAME =''test_view'')

BEGIN

DROP VIEW test_view

PRINT ''VIEW EXISTS''

END'

PRINT @sql

--EXEC(@sql)

SET @sql=''

SET @sql='USE '+@Database1+'

;

CREATE VIEW test_view

AS

BEGIN

SELECT...

this will give you all constraint in particular database.

select * from sys.objects where type_desc like '%_CONSTRAINT'

that is written in a historical stored proc and i have used the apporach u told me

but can i do it without using temptabl/table variable ?

Good catch , i also recovered the issue. but did u get any sign that this script contains

junk character before copying it to MS-word/notepad.

Msg 102, Level 15, State 1, Line 21

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 68

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line 73

Incorrect syntax near...

on simple note , i can tell u that whenver we create any clustered index on any table . the table will be moved to filegroup mentioned with that index...

I hope this will work for u

select + 'YEAR' + CAST (year(DATEADD(year,-1,getdate())) AS VARCHAR(20))