We have 2 databases running same server.
Let's call them database1 and database2.
A job was scheduled to extract data from...
Thank you KH. Your suggestions and assistance are very much appreciated.
Sorry, it worked perfectly.
Thank you for all your help, and thanks to all who contributed.
Can I just ask you a quick follow-up question, please?
If for instance I use this code you provided to show only 2 days records, this will be the...
I fell asleep on my keyboard while trying to figure this out.
Maybe, I didn't explain it well.
What I am trying to show is records from...
I fixed the error:
WHERE eventDate >= dateadd(day, datediff(day, 0, getdate()), -20)
but I am still getting all records, instead of 20 days records
Thanks so much for such rapid response.
First, yes, eventDate contains time.
Second, I am getting an error that dateDiff requires 3...
I would like to display records that span 20days at a time.
For instance, I would like our readers to view our data for up to 20days...
Downloads fieldname is an int data type and so you are right if a file is downloaded 10 times, you will see Downloads 10 times as in...
This really should not be a problem but I have 2 issues I can't seem to get right.
I have a table call Downloads with the following field...
This is now solved and you will be surprised what caused the problem in the first place.
ODBC Tracing was turned on.
Can you believe it?
Thanks so much for your continued assistance.
I did send the zipped trace file.
Besides this:<br />EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters<br />which has both the longest duration and highest cpu use,<br /><br />this is...
That's what I wanted to know.
Did you see anything outstanding from that read, though?
See, I have posted a bunch of info similar to...
sorry, that last row should look like this:
---- |1.000 |% Processor Time|_Total|-- | Processor |Computer Name
I missed the scale data of 1.000
If I could afford to get professional help, trust me I would have done it as it would have saved me tons of headache.
As for the performance...
Can someone, anyone, please just answer one question for me.
Please pretend as if this is the first question about sql server performance issues....
sometimes we consider quality based on results.
As far as I am concerned, whether this is solved or not, I am truly appreciative of...
Would it be an option to spend some money for a consultant who can directly check your system at your place?
Do you mean the database system or the...
Separate names with a comma.