I have to agree with a lot of whats already been said. On their own these low level certificates are not going to get you a job as a...

Page splits in your indexes?

As there is no increase in rows, is it possible some are being update or replaced?

Yes, you can use replication to "double hop" articles. This will add some additional complexities when modifying the topology but nothing too complicated.

Update-able subscriptions don't fully support this. ...

Like I said...

humbleDBA (4/3/2014)

---

Think it worth sayingthat, as you haven't mentioned what SQL version you are using there are some caveats with Lock Pages in Memory (LPM).

First, if you're running SQL 2008...

phil.wong (4/2/2014)

---

Been monitoring SQL server 2008 for a bit now and seems the memory usages sits between 95-95% memory usage. After reading multiple forums and recommendations from various sources,...

Angelo SIlva (3/28/2014)

---

I know that. I am not checking with that query. I am checking for all records with a query that I create yesterday for the same table.

The thing...

Just a point note, the above query only shows errors in the last 5 minutes. You have to change it to check for one outside that period.

If you find...

Angelo SIlva (3/27/2014)

---

Hello All,

The data is inserted in our Database db 1 in Table1 and replicates the data to the customer database db2 in table1 then the customer database db2...

free_mascot (3/25/2014)

---

Again standby mode in Log shipping will not allow users to use database and max you can have read_only database that too SQL removes the connection while applying the...

MysteryJimbo (3/24/2014)

---

GilaMonster (3/24/2014)

---

It'll reset if the plan is removed from cache and compiled again...

GilaMonster (3/24/2014)

---

It'll reset if the plan is removed from cache and compiled again from...

webrunner (3/21/2014)

---

GilaMonster (3/21/2014)

---

This is the problematic query taken to basics:

SELECT col1, col1 FROM SomeTable ORDER BY col1

It's the order by, it doesn't know which col1 to sort by. Wasn't caught...

You can use something like this and check the usage count, it will reset if recompiled. I forget but there may be another dmv with the compile time

SELECT usecounts

,object_name(qp.objectid)

,...

No examples of this

The principle is you have identical stored procedures on Server 1 and Server 2.

A linked server on Server 1 pointing at Server 2.

You then use 4 part...