...removed post...

GilaMonster (3/27/2013)

---

opc.three (3/27/2013)

---

At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your index,...

If you gain access to the instance via a Windows Group and you do not have an explicit Login on the instance for your Windows User that can also explain...

Sorry, I won;t be much...

At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your index, ie only...

I have only used Snapshot for a few isolated tables, e.g. a mostly static lookup or staging tables that needed to also be copied to another server nightly, so nothing...

Grant Fritchey (3/27/2013)

---

opc.three (3/27/2013)

---

Grant Fritchey (3/27/2013)

---

Actually, if you use extended events you can filter by batch_text in sql_batch_completed or by statement in rpc_completed and then use the like_i_sql_unicode_string to...

At only 30-70kb each I would look into storing them in the database in a VARBINARY(MAX) column provided the database is the only way people need to access the files...

Like I told you on the other thread, if you are concerned that auto-update stats is not doing a good enough job and you want to guarantee stats are updated...

In my experience the most common setup that suits a separate reporting database where the indexes can be different from the primary database is Transactional Replication with a Continuous Push...

mister.magoo (3/27/2013)

---

Jeff Moden (3/26/2013)

---

mister.magoo (3/26/2013)

---

How do we all feel about SQL Agent Jobs and the ability to run operating system commands from them?

(I know the user running the job will...

To clarify one point, when i said time the reorg plus the stats update, that means WITH FULLSCAN which is what you would get with a rebuild.

Huh?

Grant Fritchey (3/27/2013)

---

Actually, if you use extended events you can filter by batch_text in sql_batch_completed or by statement in rpc_completed and then use the like_i_sql_unicode_string to do a like...

Statistics are not indexes. They just describe the distribution of data. If you have time to update stats nightly then I would do that. Time the reorg plus the stats...