Hi,

as far as I am informed the "recompile" is not nested, if you recompile the topmost procedure (with sp_recompile or changing the procedure) the nested procedures are not recompiled.

But if...

Hi,

I have another query that offers nearly the same output but what I miss here are two informations.

is_unique (sys.indexes) because sometimes you do have an unique index for consistency even...

I am not that deep into the sql server lock system but as far as I know every update is running in an implicit transaction that locks the specific rows...

I can recommend this document

http://msdn.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

because there are a few good hints about when to use which compressiontype. I am sure you can write a script to do it automatically but...

Intellisense is not an improvement if you have objectsnames in your database starting with "TOP" or "ON" .... SQL-Promt from RedGate is much better if you like using Intellisense.

Nice features...

Seems like a good way to go but keep in mind to do a complete rebuild once in a while, reorganize won't "refresh" the Fillfactor (except if you are deleting...

I made a few tests with 1608 pages of data (+10 indexpages) , one int column only, 1 mio rows.

The TempDB did not grow but the datafile is bigger than...

Hi,

I am doing rebuilds/reorgs on the live database in our company and have the same issues/things seen and a few ideas how it is working.

Sort in TempDB I have not...

Prakash-205770 (12/9/2010)

---

From the view of database architect, sending emails is a business functionality and need to be hosted in a separate server as separate application! The application needs to read...

Hi,

I am wondering how you send you emails. Do you send them via an exchange-server inside your network? Or do you have some external provider sending your mails?

In the last...

cjeremy74 (7/3/2008)

I actually did use this about a month ago... we had a new policy implemented that allowed us to delete a couple of years worth of data out...

I am wondering, why not use SET ROWCOUNT ?

Normally I am using rowcount because it is really easy to handle.

Set Rowcount @n

select 1

While @@ROWCOUNT > 0

BEGIN

...