davemiller3 (8/11/2011)

---

Hello -

I have a cobol stored proc / assembly that runs the following code:

....

The SQL runs fine in both versions of SQL. It runs fine as an...

Include Action Execution plan in SSMS (check under Query). Often time, execution times can be explained by the way the SQL Server db engine decides to do similar queries in...

I think it's hilarious that you think you're not a real author.

You're writing, aren't you?

You're...

I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight scene.

If you're...

Thank you for the response. I appreciate it.

Additional filegroups also comes in handy for partial backups and segregating read/write information from read only information.

So don't assume that because everything is on the same logical drive that prevents...

You're very welcome. Let us know the results once you have them (good or bad) as that will help others who stumble across this thread in the future.

I have a separate job that executes on a 15 minute reoccurring schedule to look for files on a certain day within a certain time frame (say, 4 hours). If,...

This almost sounds like an interview question.

Are you a dev dba / BI person that just moved into a production dba position?

Maybe I misunderstood your question, but not all...

Fortunately for you, Microsoft...

Is it just me, are am I being particularly unhelpful this morning?

http://www.sqlservercentral.com/Forums/Topic1158208-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic1158308-391-1.aspx

Gail rarely needs to do prep. She's so immersed in the internals that she already knows most of what's going to be on the exam. It helps that she rescues...

Aha. As much as I don't trust Wikipedia, this article looks interesting:

http://en.wikipedia.org/wiki/Windows_Internal_Database

A quick google of the term gives me this article: http://support.microsoft.com/kb/944267. That tells me this is a Sharepoint service (possibly).

Do you have Sharepoint installed? I know SP does use SQL...

It sounds like you need to run a combination of Profiler (or a server side trace) and PerfMon while these jobs are running so you can get these numbers. PerfMon,...