I'm not snapshot the database...i'm snapshot 6 tables.

the problem is that the replication needs to run every 15 min... 🙁

there is no way to work around this snapshot locks?

hi,

I've already done that...

beside of the missing indexes how can i see the query that runs that needs this index?

this is how our ERP works with the dynamic sql statements.

i thought that maybe someone have a quick results for this kind of issues.

THX.

THX but i've manage to work this out with another script.

what i want to achieve is to insert all the tables with amount of rows in it and to insert...

my problem is that i don't want to insert all the tables in the first place only the one with rows > 100000 because i've 4000 tables in every database...

i thought that i can use the WHERE inside my query along with sp_msforeachtable and not go over all the tables.

how can i use the WHERE clause inside my query to not go over all tables,only tables with rows > 1000?

ok I'll do the execution plan history and when the issue will occur i'll update.

can i do anything on the server side to fix this issue because i can't change...

Grant Fritchey (4/2/2012)

---

It sounds like you might be dealing with a case of bad parameter sniffing. Instead of freeing the entire proc cache and the buffer cache (which requires reloading...

yes they are real but with different names.

i want only if colb = 'c:\1' while cola is 'first' and cola 'second' do not show the 'second'.

i want in the output to remove the duplicate in colb.

ChrisM@Work (8/9/2011)

---

Apologies. Actually it should appear three times:

SELECT LOG_NUMBER,

MAX_EVENT_TIME...

ChrisM@Work (8/9/2011)

---

Chooes the column you want, min or max (or average, if you wish):

DROP TABLE #Sample

CREATE TABLE #Sample (LOG_NUMBER CHAR(3), EVENT_TIME DATETIME)

INSERT INTO #Sample (LOG_NUMBER, EVENT_TIME)

SELECT '002','2011-08-07 20:29:05.787' UNION ALL

SELECT...