at least one person thought so (no it wasn't me :-))

Koen Verbeeck (7/19/2013)

---

george sibbald (7/19/2013)

---

renamed to SSDTBI to avoid confusion! could have fooled me.

So with SQL2012 and 2014 install media we dont get the option to install the BIDS equivalent?...

renamed to SSDTBI to avoid confusion! could have fooled me.

So with SQL2012 and 2014 install media we dont get the option to install the BIDS equivalent? that sounds a backward...

me neither

george sibbald (7/18/2013)

---

SQL_Surfer (7/17/2013)

---

Thank you so much for your suggestion. How about is there a way to figure out which stats are mostly used and needs updated?

Another question...For two 150...

SQL_Surfer (7/17/2013)

---

Thank you so much for your suggestion. How about is there a way to figure out which stats are mostly used and needs updated?

Another question...For two 150 GB database.....both...

no problem

Everyone? Who did I miss?

if something is continually trying to connect it could do that.

time for sp_who2 🙂

yes it would so you must set max memory in SQL (as I believe you have done at 2.25?)

I have never seen messages like that in the errorlog before which made me ask about third party tools.

thats a point, is someone connected to the secondary preventing the restores...

Stefan Krzywicki (7/17/2013)

---

I've been having my own little annoyance with something SQL Server related lately. If you use SSIS to create text files and save it from one server to...

you will only be able to do that if a full backup does not run after the log shipping broke and before you take your differential, so beware.

Has a log...

thats not possible, are you sure the secondary is up to date? run this on the secondary

-- tells you last log copied and restored, primary and secondary server names

select *...

yes it requires a reboot. They'll have to reboot it some time if they want it fixed.

You will know more after increasing memory SQL can use.

If PLE is consistently low...