Well, the create date of tempdb is September 7, 2011 and of the five indexes that don't have any user seeks/scans/lookups 4 of them don't have any system scans/lookups either.

The...

I also posted the wrong version of the query. Should be an s.* at the end of that SELECT list.

I'm trying to figure out what a system process would want with it. If it's something like a consistency check then it's usage that isn't important because it doesn't...

Also, source http://technet.microsoft.com/en-us/library/ms188764(SQL.90).aspx

I found a stored procedure that lets you mark rows to be skipped if they error

sp_setsubscriptionxactseqno @publisher (name of publishing server),

...

Any idea if it's safe to delete rows from distribution.dbo.msrepl_commands? I know the two rows I need to oust.

Touche' sir! Thanks. Now to fix this mess...

msumption (9/7/2011)

Hmmm, ok, if you say so even though the error...

I would make a new topic with a different title. Seems like a very different issue to me.

Well, it seems I can't lock pages in memory because when the server was set up the Service Account was made to be Local System. I probably have to...

Glad I'm not alone 🙂

I'll leave this thread for a few days and...

Thank you, and apologies for my ineptitude.

Still haven't enabled it because I don't know exactly what Microsoft means by

My guess is the account that the SQL Server...

I'm assuming I have to add the sql server service account, yes?

HowardW (7/29/2011)

About performance issues with SQL Server and Paging, SQL Server Memory Management...