I would think they will have the same problem distinguishing names with the current setup. If the asterisk is a delimiter of some kind, then it could be useful to...

I meant to say I have a server side trace running. I did not make any changes to the system default trace which is also running.

Not quite sure how to translate any of this into "bandwidth". If you have users or applications returning large data sets from selects, they are using bandwidth, but there are...

Maybe transaction log backup sizes would be more useful than a diff ?

In a simple world, it looks like a good opportunity to use the '*' to split the field into 3 columns:

FName

MName

LName

Gives you much more flexibility for future needs.

I have a default trace running 24/7 that I can use to troubleshoot. You could set one up for the future. Then look at activity in the timeframe between log...

Although the job was enabled, perhaps the schedule was not enabled ? Since you deleted the schedule, you cannot find the answer now.

Are you suggesting I am dysfunctional ? 😀

We use a product called StrongMail that queries againt our SQL database. Sorry, but I don't know any details about the process.

Is your purpose to not have any files more than 2 days old ?

You could try the Windows utility FORFILES. It has different syntax based on your Windows version. I...

Maybe "orphaned" was not the best word.

Dird (5/21/2013)

---

Ross.M (5/21/2013)

---

Also, when you first start this sequence of backups going, there would not be anything to overwrite, so surely it would not break just because it doesn't have...

I also have old "orphaned" active jobs. I ran across it a few weeks ago when creating a report to alert me about long running jobs and failed job steps....

Yes, you could quite possibly have improvements by directing queries to a replicated database. Less chance of blocking and generally less demand on the primary database.

Many people set up reporting...

Select statements can absolutely affect performance.

Can you expect improvements ? That's hard to say without know the cause of the problems. If the problems are built into the application,...