Because you can't concatenate within an EXEC

DECLARE @b-2 INT;

DECLARE @action VARCHAR(100);

DECLARE @dbname VARCHAR(100);

DECLARE @a INT;

SET @dbname = 'adt';

SET @action = 'dfgf';

SET @a = 14;

SET @b-2 =12;

DECLARE @Result VARCHAR(500);

SET @Result =...

Ok, couple more steps back and in more detail please?

I'm trying to see if there's another way, because row number won't work the way you're using it. Need more details...

Row number always starts at 1 for any query.

Couple steps back, what are you trying to do here?

What's normal for this server for those counters?

Why are you looking at page faults specifically? Do you have a lot of non-SQL apps on the server which are getting paged...

Locked pages may not be required here.

No indexes, so a heap?

You've probably run into the scenario where pages aren't deallocated after deletes. Create a good clustered index, see if that fixes the problem

Did you read the blog post I referenced?

I do hope they're not 16 individual drives each with one filegroup on. If...

Not when there's transactional replication.

p.s. 3 year old thread.

In what context did you encounter those terms? Neither is a SQL Server term.

Possibly safe to ignore. See http://blogs.msdn.com/b/psssql/archive/2009/05/12/sql-server-reports-working-set-trim-warning-message-during-early-startup-phase.aspx

Last line mentions this can be seen on servers with no user databases

If you're interested in engaging a company to do this for you, drop me a PM and I'll give you my boss's email. I'm in South Africa, but have no...

AFAIK, the last backup date comes from MSDB and the data in MSDB is not synced across an AG.

You can sync the data yourself, the backup history tables in MSDB...

No, I said nothing...

curious_sqldba (8/15/2014)

---

Ok, i have a application generating about 10,000 transactions read/write per hour. we have 50 + clients, should i partition per client ( data has to be separated) or...