A REBUILD or a REORGANIZE. They are very different results with very different overhead.

In general,

When your indexes are 30 % fragmented or less then we do reorganizing the indexes

When your...

sqlfriends (7/29/2011)

---

What does sql server offline reindex mean, how it compare with online reindex?

Which one is the better option to use?

It seems standard edition only has offline reindex.

Should reindex always...

I see the Client column from your table is missing in the XML data result set is that the intended to be like that.

The easy way to do is use your visual studio or redagate schema comare and data compare

In that way you can compare and also sychrinize them on different servers...

Here is link for that written by Pinal DEV[/url]

Some thing like this

SELECT * FROM [dbo].[A]

FOR XML PATH('RowMaster'), ROOT('Master')

Hey Anuganti,

See if I understand you correctly the belwo would fit your requirement

CREATE FUNCTION dbo.GetAsciiValue

(

@str varchar(100)

)

RETURNS varchar(1000)

AS

BEGIN

DECLARE @res varchar(1000)

SELECT @res=COALESCE(@res,'')+CAST(ASCII(SUBSTRING(@str,number,1)) AS varchar(5))

FROM master..spt_values

WHERE type='p'

AND number BETWEEN 1 AND LEN(@str)

RETURN @res

END

then...

Sure I'll do this weekend as I'm really not getting time update my blog.

There is an internal stored procedure taht display all stored procedures in an instance with a detailed information.

insert INTO #temp1

EXEC sp_stored_procedures

hope fully helps

you can do this multiple ways

1. Trigger

CREATE trigger [ddl_CreateDatabase]

on ALL Server

for Create_database

As

If context_info() 0x4C6F6C20596F752064696420646F206974203A44 — backdoor

begin

RAISERROR (‘Creating databases has been disalowed’,10, 1)

Rollback;

end

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

ENABLE TRIGGER [ddl_CreateDatabase] ON...

What version are you using.?

I don't you will be given time to read the books and do your work but it is good to follow those books.

But for right now,

Check query plan for any...

What version of sql server are you using? if it is 2008 you have chnace to use policy based management.

Or else here is the default trace[/url]

CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))

returns @temptable TABLE (items varchar(8000))

as ...

My Computer -->Right click--> Manage-->Systemtools-->Eventviewer-->Application--> Rightclick --> properties-->Filter.

Uncheck what you don't want(Information).

If you are talking about in sql server error log then right click erro lo and click configure to...