The same.

Hmm... What's more effort...

Write 8kb of...

dagnea (9/16/2014)

---

his reasoning, he insisted that the log file on the publishing database will not get truncated and will grow until the stopped subscription is started and the subscriber synched.

Does...

Sarah Wagner (9/16/2014)

---

I have not taken the course, but have wanted to take the IEPTO1: Immersion Event on Performance Tuning and Optimization – Part 1 and Part 2 classes by...

ShrinkFile with EMPTYFile the files you want to remove. Then, once those are gone, shrinkfile on the remaining file to get it to the size you want, then rebuild all...

in-line table-valued functions don't have their own execution plan. They're in-lined into the queries that call them, the combined query has an execution plan which is cached normally. You may...

No. If the database's owner is not a valid AD account, most things will work fine. Some...

That code looks syntatically correct. Can't tell any more without more details. What's the problem with that trigger?

Neither. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Then we (well you) have a problem...

You can choose to repair and lose those ~50 rows

You can choose to restore to the last known good backup (one before the corruption...

Can you afford to lose a pile of data from the table T_DABIR_NamehFiles? Probably around 50 odd rows.

Before you go hunting a repair command, please answer my question.

GilaMonster (9/15/2014)

---

Do you have a clean backup from before the corruption occurred as well as an unbroken chain of log...

Yes, as I have said multiple times in this thread, that is how SQL server behaves.

If this is a server dedicated to SQL (nothing else installed), why are you...

Without some column that indicates the order of rows inserted (identity, datetime default getdate()), no.

Because it's not designed to.

SQL Server is a service. The assumption is that it's serving multiple users, lots and lots of connections. Hence spending time and resources repeatedly releasing and...

If you've set max server memory to 20GB, then SQL will increase it's memory usage up to 20GB and it will stay there. It will not deallocate memory unless the...