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...

I missed that I think, where was it?

Here's an alternative:

declare @children int

set @children = 4

SELECT

string,

STUFF(string, start_of_integer_value, CHARINDEX('<', string, start_of_integer_value) - start_of_integer_value,

CAST(@children...

Replace "<your_db_name>" with the restored db name:

ALTER AUTHORIZATION ON DATABASE::<your_db_name> TO sa

USE <your_db_name>

DROP USER <user_name>

I typically see %s with one decimal place. If you want more, adjust the "decimal(4, 1)" to (5, 2) or whatever you prefer.

SELECT EmailID, Email

,[%...