You said it was capped at 41GB. It will always grow to 41GB as you use the server.

No concern, no curiosity. This is how SQL Server works. Every query reads...

Are you saying that 41GB is high? If you set the max to 41GB, the SQL Server instance will use 41GB. All the RAM that isn't needed for queries is...

Agree with above. If you have a 2 node cluster then if there is a failover, you will be sharing 64GB among three instances. If you don't set max/min for...

Congrats, and glad you made such a big change and meet your challenge

You need to build two things.

1. How do I examine the data and determine if the current execution is long. Meaning, am I looking at the mode, the average, weighted...

Often people use a dateadd/datediff combination to remove times, or to set to a base time.

SELECT DateAdd(Day, Datediff(Day,0, GetDate() -1), 0)

returns midnight of yesterday. That might be what you want....

The way in which queries are formatted is very subjective. Some people like this:

select col1, col2, col3

from mytable

inner join myothertable on col1 = myfk

where time < getdate()

others prefer more indentation.

select...

I'd also ask people in the company. It's possible someone runs SSIS or performs manual imports from their workstation.

Alvin Ramard (11/25/2015)

---

Steve Jones - SSC Editor (11/25/2015)

---

The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't...

You could track the times in sys.jobactivity. You would need to create an average, or max, or whatever statistical calculation you want. Then you'd need to track the current execution...

The spam problem is tough. Believe me, no matter what we do, people will find ways around it. Much of the spam isn't a user clicking and posting like you....

I know this is old, but did you recover things?

Also, please don't set emergency or use repair allow data loss. You have errors in low numbered system objects, which are...

Thanks for noting that I mirror Keith poorly. :hehe:

DonlSimpson (11/24/2015)

---

Yeah but isn't that using a butter knife as a screwdriver? Certainly you can, and many people and organizations do, use the database server as the staging area...

I was using window functions, and this appeared to work, but it's a small sample size, so perhaps there's a flaw here:

SELECT t.*

FROM ( SELECT top 10

...