Kwisatz78 (7/22/2014)

---

Hi there

I am using Ola Hallengrens scripts for index and stats maintenance but I am wondering what most people to in terms of the maintenance schedules. At present...

npittson (7/18/2014)

---

Thanks for your reply.

After I posting I began scouring the net trying to put something together, in the end I found this worked for me:

CREATE TRIGGER dbo.MyTrigLI ON dbo.MPanel

FOR...

tcronin 95651 (7/18/2014)

---

been a sqk dba for 20 years your response was fairly condescending, I completely realize disk IO is a big factor, current db less than a terabyte and...

tcronin 95651 (7/18/2014)

---

Trying to make things happen in budget. Considering trying to move 2008 acitve/passive cluster with log ship to day old read only 2008 server to 2012 active/passive...

npittson (7/18/2014)

---

Hello All,

I would like to change a value after the table updates \ inserts a new row based on the value of that column

Table Name is: MPanel

Col Names: RID,...

Dang!! I love having a way to expense a trip to the Big Apple! 😎

I am making a presentation entitled TheSQLGuru's Free & Low-Cost Tools, so you will have to catch that somewhere to get all the goodies!! 🙂 But here are a...

Newbie0809 (7/11/2014)

---

When using the GUI to restore a copy only full backup (from the secondary) and subsequent trx log backups, it fails complaining about a break in the LSN chain....

Newbie0809 (7/11/2014)

---

Hi,

We have just implemented a SQL 2012 always on environment. We have a primary and secondary server. I am confused about how to set up the backup...

Can I ask why you care about those objects and why you feel the need to remove them?

I agree: if you HAVE to do this one row at a time then a properly defined cursor is the correct way to do it. FAST_FORWARD or FORWARD ONLY,...

Adding files onto a disk subsystem that is already overwhelmed can only make things WORSE!!! You will be INCREASING disk seeks and head thrashing.

chengchong36 (7/9/2014)

---

Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few...

ApexSQL has a compliance product that has been out for a long time. Tell them TheSQLGuru sent you - maybe you can get a discount. 🙂

TSQLLearner2014 (7/7/2014)

---

Given the situation where we had to put a hot fix asap... This worked brilliantly. We have now time to fine tune the code.

I will now try using the...