I bet you were doing STATEMENT completed (which the default Tuning trace in Profiler traps), in addition to unnecessary bloating columns like application name, database name, etc.

Here is my Profiler...

You seem to know the time this occurs so you can set up an XE capture to get the batches submitted. You can do the same with sql trace...

Right here on SSC!!

http://www.sqlservercentral.com/search/?q=sql+server+build+list

Balance (1/7/2015)

---

We have a server that has had a performance issue, for us it is a busy server and normal service has been resumed since a rollback of something that...

What are you really trying to do here, and more importantly why are you trying to do it?

This isn't 100% accurate, but it will get you close

select object_name(object_id)

from sys.sql_modules

where definition like '%mytablename%'

and definition like '%join%'

dbcc memorystatus

partially documented online

knikolov4521 (1/4/2015)

---

Hello, can someone help me with this:

I have two tables. I have three columns DEPARTMENT_NAME, LAST_NAME, JOB_ID.

DEPARTMENT_NAME is from table 1. JOB_ID and LAST_NAME are from table 2....

2 queries and 2 passes is the best way to do this I think. You could try the Import Wizard in SSMS as a starting point.

What, exactly, are you doing with SQL 2012?? Any configurations or usages that you did not do/have on 2005?

Have you run any DMV queries to determine what...

brewmanz (12/22/2014)

---

Dan Guzman - Not the MVP (12/19/2014)

---

Gaps I don't mind, but really 1000 or 10,000 at a time? It's too much. I guess if you only reboot...

I can't take sufficient time to wade through all of that output, but it seems that you are hitting system tables with activity (read and possibly write with a create...

Yes, it is in SQL Server 2014. And it IS by design, and for a good reason. The logging of each individual identity created is a SIGNIFICANT performance...

I have used this sproc for nearly 15 years to generate insert statements for a table of data:

http://vyaskn.tripod.com/code/generate_inserts.txt

We don't want to deal with that much data though. Create sample...

Dwain, I think the objective is TOP N Per Group. But I am waiting back on definitive confirmation of that from the OP.

Serg, the BETWEEN doesn't seem appropriate because...