Posts
Sort by recent activity
Can you calculate a substring based on another column?
I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is populating a column of file extensions based on a full filena...
Can you offset from a date in another table?
I'm evaluating a trial version of data generator and have a few scenarios that I'm wondering if the product can handle. One scenario is offsetting a date based on a value in another table. For exam...
Can I add machine wait metrics to reports?
I would like to create a report in SQL Monitor that will send out a monthly summary of the machine overview items, so that I can go back periodically and see how my machine stats compare with those...
Why can't I match longest running queries report tile to a long running query alert
A co-worker told me I had better look at one of his sql monitor reports because I had a query that was taking longer than a day to run. He has the Longest running queries tile included in his repor...
How can I get a more precise long running query start time?
I am researching a high resource usage event from yesterday and wanted to get a handle on which event came first. I have long running queries on one instance and deadlocks on another instance. With...
How can I see alerts for a given database?
On the alerts tab, I can drill down to a server, then an instance, and then a database. However, it seems that most of my alerts do not appear when I click on a particular database. For example, I ...
What are the recommended system specs?
I have several long running sql data compares that run throughout the day. I just noticed that the box they are running on only has 2GB of RAM, and I'm wondering if this is a factor in the length o...