Agreed, Developer's Edition is a wonderful, and very cheap considering, product for what you're talking about.

Also, get a good book on SQL Server 2008 (or later) Administration. Kalen Delaney's...

Jeff Moden (12/26/2014)

---

Thanks, Scott. I was afraid it would be something like that. I can see those reasons for companies back when spreadsheets where 11x17 accounting papers that...

I don't understand the point of:

"PARTITION BY (SELECT NULL)"

in the LAG. Why not just leave out "PARTITION BY"?

SELECT a.id,

CASE WHEN match_found.address_id IS NULL THEN '' ELSE address1 END AS address1,

CASE WHEN match_found.address_id IS NULL THEN '' ELSE address2 END...

To be sure, make SQL update the page (and row) usage counts and see if there are any large discrepancies:

DBCC UPDATEUSAGE ( '<your_db_name>' )

Jeff Moden (12/25/2014)

---

CELKO (12/25/2014)

---

The last time I looked the GAAP had...

Jeff Moden (12/25/2014)

---

ScottPletcher (12/25/2014)

---

Geoff A (3/3/2013)

---

Jeff Moden (2/28/2013)

---

Shifting gears a bit, I’m glad that these are essay-style questions so that I could write in what I believe is a more...

Geoff A (3/3/2013)

---

Jeff Moden (2/28/2013)

---

Shifting gears a bit, I’m glad that these are essay-style questions so that I could write in what I believe is a more correct answer in...

Excellent! Best overall set of SQL developer interview qs I've ever seen.

I think this is a much simpler method:

DECLARE @first_fiscal_year smallint

DECLARE @number_of_years tinyint

SET @first_fiscal_year = 2014

SET @number_of_years = 10

------------------------------------------------------------------------------------------------------------------------

DECLARE @fiscal_years TABLE (

year smallint PRIMARY KEY,

...

Keep in mind that procs are listed only as long as they are in the cache. On a memory-constrained or busy server, stats could be lost/removed. Also, whenever...

Be careful! Do...

Markus (12/23/2014)

---

They way I do my refresh db jobs is the first step of the job is the kill step, second step is restore. They happen back to back...

Michael Valentine Jones (12/20/2014)

---

Could you try the statement below on a development or test server using a full sized table?

The storage size for numeric precision of 12 or 18 is...

KILL is never a verified way to do this. A session(s) could immediately restart itself and start using the db again.

If you don't want to use "SINGLE_USER WITH ROLLBACK...