Revenant (1/4/2012)

---

Dev (1/4/2012)

---

Revenant (1/4/2012)

---

Yes, from say American perspective. However, foreign countries are not obliged to follow American law with its 70 years copyright extensible by another 70. ...

By mayan's calendar! yes the incomplete one we're all hearing...

Awesome, c u tomorrow 🙂

Great, so you'll be done by friday 4PM?

L8rs :hehe:

Close enough. I generally don't like hints but this one is fine.

Ugly, but close enough to what you need.

There are better table spaces scripts but I don't have the links right now.

SET STATISTICS IO, TIME OFF

SET NOCOUNT ON

SET IMPLICIT_TRANSACTIONS ON

GO

USE [master]

GO

IF...

I've done it to save default parameters (for each user).

I've done it to mark rows as processed or ignored or printed.

That's about as far as I'm willing to go. ...

Nothing weird in there.

It's just long to process that much data.

Kiara (1/4/2012)

---

Brandie Tarvin (1/3/2012)

---

So, skirting the edge of the "no tech speak in The Thread" rule...

How is your first week of 2012 shaping up work wise? Are you in firefighting...

Of course.

What does this return?

/*

Cost threshold for parallelism (CXPACKET) http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/01/19/tuning-cost-threshold-of-parallelism-from-the-plan-cache.aspx

Paul White: Understanding parallelism http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/

Microsoft White Paper on waits http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

Next query by Paul Randal http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx

*/

WITH Waits AS

(SELECT

...

derekr 43208 (1/4/2012)

---

Ninja's_RGR'us (1/4/2012)

---

Depends on what you call complete.

I have a few jobs that save data to a perm table, then the last step of the job (no error exit...

Depends on what you call complete.

I have a few jobs that save data to a perm table, then the last step of the job (no error exit path), you can...

GilaMonster (1/4/2012)

---

It's far more...

Stefan Krzywicki (1/4/2012)

---

Brandie Tarvin (1/4/2012)

---

Wow....

Ultimately it comes down to you need to trust the guy(s) who do that job.

Doesn't matter how much security you put in place, anyone with SA access can go around...