Bull! I'm telling you, don't...

Jeff Moden (12/30/2014)

What a lot of folks also miss is that you can add and subtract formatted times as constants instead of jumping through multiple datepart hoops, as well.

...

sgmunson (12/30/2014)

---

You didn't mention what technology "DAS" is, but I have to assume that since local disk is faster, that it's probably a SAN. Are you good to...

Don't believe there is a command/query that can see that directly from SQL Server.

Charles Kincaid (12/22/2014)

The only other reason that I can see for something like this is since the Datetime format uses a singed integer for the date portion that there might...

Keep in mind that using the clustered index...

Btw, either add 1222 setting directly to the start-up flags or add it to a start-up proc. Otherwise you'll lose that flag setting when SQL stops and restarts.

Jeff Moden (12/29/2014)

---

Phil Factor (12/29/2014)

---

We use only the 2 part name and let the synonyms do the rest of the work. Do you know of a way to do a...

Looks to me like they used 1904 as the base year rather than 1970. That would be quite logical if they needed to show dates before 1970, such as...

Easiest might be to add a UNION [ALL] with a "NOT EXISTS" clause. Btw, I don't see any reason to do UNION rather than UNION ALL so I've used...

I think you need to order run_date DESC also, not just time:

ORDER BY h.[run_date] DESC, h.[run_time] DESC

Also, I don't see a need for a separate CTE_Restore_JobHistory2. You can...

chip.halsey (12/29/2014)

---

Thanks for the good list of interview questions. I thought that the answer to question 15 might be 1 but I was really expecting an error. If...

Or, more specifically, run these commands:

DBCC TRACEOFF ( 1204, -1 )

DBCC TRACEON ( 1222, -1 )

You should make it a clustered index. You should also explicitly specify the appropriate FILLFACTOR and filegroup (even if it's PRIMARY, as that may not be the current default...

A FULL OUTER JOIN should handle this rather easily. From what you stated, a FOJ should be available to you.

SELECT ca1.Cust_id, ca1.Rec_id, ca1.Rec_type, ca1.Update_TS

FROM quote_table q

FULL OUTER JOIN sell_table...