ratheesh4sql (3/2/2013)

---

Hi,

Thank you very much for your reply....

Using the Ola.Hallengren.com scipts..am not able to take the full backup of my Always on Seconday database.

Can u suggest me to schedule...

You have known me long enough Jeff to know I wouldn't run that test into SSMS output! 😉

My laptop being so powerful has actually forced me to do...

I recommend against using statistics time on to capture timing metrics too.

Jeff Moden (3/1/2013)

---

TheSQLGuru (2/28/2013)

---

I would honestly expect (but not certain here) that a scalar UDF that just puts it's output into a variable would be more efficient than iTVF that...

ratheesh4sql (3/1/2013)

---

Hi All,

Can u anyone suggest me for best practice maintenance task in sql server 2012.

I am planning to do the following in my Always on server- Production database.

1. Full...

ApexSQL and Red-Gate both have very good schema (and data) change management products. I there are some free alternatives out there but in this case believe you get what...

This thread has...

Zeal-DBA (2/27/2013)

---

hello,

in ma current configuration i have one data file and one log file of a tempdb database.

as a process of tempdb optimization i am going to add 16 Data...

There really is more to it than just the...

Alan.B (2/28/2013)

---

Jeff Moden (2/25/2013)

---

Inline...

A few guesses (based on very limited information provided and a few answered questions):

1) You have much faster IO now and it is able to "swap out data" in RAM...

You can do THAT TOO in SQL Server?!? Jeez, what a suck-@ss product! :w00t:

You may THINK you want to do a Scalar UDF, but you probably don't. I wrote a chapter for the SQL Server MVP Deep Dives 2 book entitled "Death...

1) Your server would likely die a horrible death if you set up replication on 500 databases, unless they were mostly read-only.

2) Likewise for database mirroring (even asynchronous).

3) I built...

recommendations:

1) see here:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note there are 2 additional parts to this blog series.

2) as someone else said, you will likely need to batch up the DELETE.

3) you...