You could put in a start up procedure that sends you an email each time the server comes online. That wouldn't tell you it was going down, but it would...

There isn't a single path to the goal. You actually sound like you're already doing a lot of what many DBAs do for their entire career, set up servers, set...

The query is the better approach.

The index is fragmented. It's just not very fragmented. 34% is fairly light. As for scripts, just search for the names that I provided. You'll...

mrupperman (3/24/2014)

No, I just created the plan and saved it....

Nope. I keep getting errors in the XML when I try to open it. Did you edit the plan?

Are there differences between the cost threshold for parallelism between the two? How about optimize for ad hoc? Are there differences in the amount of memory or CPU? When you...

Without seeing the indexes, I can't even guess at what to do.

A seek is dependent on the WHERE clause being able to use the statistics that define the data stored on the index. Not seeing your query, I can't make suggestions...

I'd suggest using extended events. You can capture the recompiles and you can filter the event so you're only capturing information for the query or stored procedure in question. It's...

Backing up across a network like that can be slow. A better approach is to backup locally and then copy the backup over. That way, the copy process can run...

Solid State Drive.

It's a drive that uses memory like it was a spinning platter hard drive. So, it's just a drive. SQL Server uses it like any other drive. Just...

That looks like hardware as a bottleneck. It's the writes that are going slow.

I'm pretty sure you posted this in the right spot. Although you could go to the Employers and Employees forum or maybe Resumes and Job Hunters. But I'd think you'll...

But now you have that $lastwritetime construct in there. That's what's giving you conniptions. Check the documentation on test-path again. There isn't a date filter that you seem to be...

Pretty sure it's this bit

Test-Path -Path "\jfocus01\WFMASTERS\Created\$file3*.tab" -eq (get-date)

-eq isn't a parameter for Test-Path.