Michael T2 (12/13/2012)

---

using that, i still have the table scans. if i only use

and (txSubtype > 'BACKORDER'

or txSubtype < 'BACKORDER'

then the scans go away.Strange.

I am going to read up...

Great, thanks, job done.

Sarging the WHERE clause to:

WHERE [DateTime] < DATEADD(hour, 48, @MaxBuffer)

did the trick and gave an index seek rather than scan, right upto "top(90,000)" (and...

Many thanks guys for all the replies and suggestions.

I have forced the serial plan for this one query using maxdop1.

I did also out of interest temporarily try upping...

Michael Valentine Jones (8/10/2012)

---

I agree on the having a different account of each SQL Server with a long random password, but I think you need to store the password. ...

It runs quick on my server!

(< 1sec)

Ok got it!

Looks like the xml records have a typo on our system -

<SchedluerMonitorEvent>

should be

<SchedulerMonitorEvent>

!!!

Hope this helps anyone else in the same boat.....

Rgds, Dave

Hi MarkusB,

I'm running your script for the cpu ticks, it's great thanks.

However it returns only null values in the output (the timestamp is fine....) like this:

2012-03-21 14:18:54.977NULLNULLNULL

2012-03-21 14:17:54.977NULLNULLNULL

2012-03-21 14:16:54.980NULLNULLNULL

If I...

An interesting example of data gravity and cloud computing and personal data being physically held somewhere with more lax laws in your editorial Steve.....

In Europe, at least, I think the...

The initial size is the size that you have set (or left as the default) in the model database for that sql server.

In mine it is set to 3MB for...

Bah!

Msg 8152, Level 16, State 2, Line 91

String or binary data would be truncated.

The statement has been terminated.

Since the engine was trying to run the program, the least it could...

i have two tables....1st one has columns name RlseId and a datetime column..

2nd table has TrackID(primary key,automatic generated) , RlseId(foreign key of 1st table) and RlsTrackId...but no date time column...

whenever...

i want the last 5 rows based on last insertion...because i don't have any date time column...so how could i get it..?

more over my requirement is to get the...

Although they may not always be in random order, I find it best if all rows are treated as being in a random order!

Until sorted by "order by".

🙂

Doh!

Do you have a business requirement behind this request? If so, what is it!

When you say the...