In my experience I normally find that excessive printing to the messages pane is the cause of excessive memory usage by SSMS.

Run this and watch SSMS grab all the memory...

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says...

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says you can't remove fragmentation...

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your claim that Paul says you can't remove fragmentation is wrong. Paul doesn't...

Welsh Corgi (5/20/2014)

---

You are right you can't set the Identity Property to true.

You can set the identity property to false by simply going into design mode and set the property...

You can't turn an existing IDENTITY off and you can't make an existing column IDENTITY. However you can add an IDENTITY column to an existing table.

Any indexes should be scripted,...

What do you mean?

Change the column that is an IDENTITY?

Add or remove an IDENTITY column?

Change the seed?

DECLARE

@NumberOfRows INT = 10,

@PageNumber INT = 2;

SELECT

name

FROM

sys.tables

ORDER BY

object_id

OFFSET

(@PageNumber - 1) * @NumberOfRows ROWS

FETCH NEXT

@NumberOfRows ROWS ONLY

GO

Hugo Kornelis (1/16/2014)

---

Isn't this like saying that cars...

I agree it's a nice question but ambiguous.

The question...

That was a great question. Thanks.

You must be manipulating the string at some point between getting the definition and executing the dynamic code otherwise the create statement will fail creating a proc with the same...

Green Armchair (1/10/2014)

---

Hi

I am testing updating statistics using the "WITH FULLSCAN" option.

Updating one set of INDEX stats takes a few minutes, but updating one set of COLUMN stats on the...

I simply mean a unique string in the html contents that the generate proc creates. Then you can use the REPLACE function at display time.

In the generate proc you should define a placeholder for time and in the show proc you can replace your placeholder with the time.

This does sound like a job for...