The query that got me the above resultset

Declare @unuseddbs Table([last_read] NVARCHAR(255), [last_write] NVARCHAR(255) )
INSERT INTO @unuseddbs
EXECUTE master.sys.sp_MSforeachdb 'USE [?]; WITH agg AS
(
SELECT

Eirikur Eiriksson (10/22/2016)

---

MVP_enthusiast (10/22/2016)

---

Last night I just migrated one of my busiest databases from SQL 2008 to 2012. Max server memory allocated to SQL Server In 2008 was 50000 and...

Jeff Moden (10/22/2016)

---

Personally, I think that if you have a heavy (read that as "frequent") usage database and it takes more than 5-10 minutes for most everything to settle into...

Hello! what do you mean when you say...

Mladen Krstonosic (10/27/2008)

---

Maybe will help to someone:

here is what i did,

select * from openquery

(LINK_LINUX, 'SELECT id, inf_date_open, inf_date_clos, inf_prob_type_no,

CAST(inf_prob_desc AS varchar(4000)) AS inf_prob_desc,

...

I appreciate your response but I'm not really sure how you intended for me to use that. Can you make it a little clearer for me? I appreciate

Beatrix Kiddo (3/3/2016)

---

Hi- I'm not really sure why you're referring to a...

Orlando Colamatteo (2/16/2016)

---

TheSQLGuru (2/16/2016)

---

Just have a job step that starts the next job you want to run AFTER the completion of the first job. Easy-peasy-lemon-squeezy! 🙂

sp_job_start is the sproc IIRC....

Orlando Colamatteo (2/16/2016)

---

Maybe semantics, but wasn't thinking of anything to incorporate in your existing code. I was proposing new code and a new step 2 in your job.

Suggestion: make...