derek.colley (7/25/2012)

---

To be picky 🙂 that is only true for 2008 Standard. 2008 R2 allows backup compression in Standard ed.

ScottPletcher (7/25/2012)

---

Sean Lange (7/25/2012)

---

ScottPletcher (7/25/2012)

---

I think the code below should at least be close to what you need (hopefully very close :-)):

ALTER TRIGGER UPDate_PONumber

ON dbo.PurchaseOrderDetail

AFTER INSERT, UPDATE, DELETE

AS

UPDATE PON

SET SubTotal...

Also, have...

Another option is poorsql.com Just have them copy and paste the proc, then get the formatted version and copy and paste it back into the editor. I only use...

Run this:

SELECT DATALENGTH(CAST('555555555' AS NVARCHAR(10)))

NVARCHAR holding 9 characters is 18 bytes. VARCHAR holding 9 characters is 9 bytes.

Tim Hiller (7/24/2012)

---

Great followups - appreciate it. Just for background, we are getting ready to migrate to another data center. The detailed implementation task that I'm looking to qualify, is...

One to start: http://www.sqlskills.com/blogs/joe/post/What-sysdm_db_index_usage_stats-may-not-tell-you.aspx

What if the table has no indexes? What if none of the indexes are used in the query? I understand this is unlikely, but it is...

What happens when a process is only run once...

Daxesh Patel (7/24/2012)

---

I am not sure I understood it clear. But you log result of following query at nPM and nAM and compare the resultsets should give you what you...

Why are you using a wizard for the same version? Why not just backup and restore?

What does 'referenced' really mean? Without defining that, nobody can help you.

I hope to be that "specialist" in a couple of years...

GilaMonster (7/20/2012)

---

It's covered in Chapter 1 and 6, and probably most of the others...

If you are interested in wait types. Pinal Dave has a great series here.[/url]

Ok, let me ask you this... How much data do you have on a monthly basis? How many months worth of data do you have? I ask because...