Viewing 15 posts - 31 through 45 (of 87 total)
You can use the Performance Dashboard report and the DMVs, however I find that SQL Profiler is much more powerful.
July 19, 2010 at 1:44 pm
Sorry Maxer that data isn't available in that part of the Activity Monitor. It's available in the Processes report, which is what I thought you meant until I read...
July 19, 2010 at 1:32 pm
Sorry just noticed you posted in the 7,2000 forum. ROW_NUMBER() function is not available in those. You can join to a tally table to achieve what you want....
July 19, 2010 at 1:27 pm
Auto generate it with what data values? Integer values? If so, then you can use the ROW_NUMBER() function if you are using 2005 or 2008.
July 19, 2010 at 1:26 pm
Yes it can be done via VB.NET, anything that can be done manually can be done programmatically. You will need to write business logic into the program that determines...
July 19, 2010 at 1:15 pm
The spid is available in the activity monitor. You should even see the account.
We use SQL Profiler though to see what's going on. Activity Monitor is...
July 19, 2010 at 1:11 pm
If you choose to use database mirroring with a database snapshot, then you need to ensure that none of your data files is over 64GB in size. There's a...
July 19, 2010 at 1:09 pm
High CPU utilization is typically due to missing indexes. When the CPU is pegged at 100%, run PerfMon to track the heavy hitters. Analyze those with high CPU...
July 19, 2010 at 12:27 pm
Have you specified the /PERSISTENT switch in the NET USE command?
July 19, 2010 at 12:04 pm
You do not need to rebuild the table, you simply need to rebuild the foreign key. DROP/CREATE the foreign key.
July 19, 2010 at 12:00 pm
We use database mirroring for such a scenario. You can prep the mirroring a few days in advance, even do it async to avoid the performance hit. And...
July 19, 2010 at 10:44 am
Use async database mirroring or log shipping. But really your issue is not exactly clear. High availability is not the same thing as performance, so we're going to...
July 17, 2010 at 2:24 pm
You can use HTML in sp_send_dbmail. Check sp_send_dbmail in BOL for details.
Alternatively, you could put attach the query results, which would probably have better formatting than what...
July 16, 2010 at 8:11 pm
You can change it under the other one if you want. I only ever touch the IPAll section. If you have multiple ones and they use a different...
July 16, 2010 at 4:28 pm
Viewing 15 posts - 31 through 45 (of 87 total)