DBA Tools: sp_whoio
The Stored Procedure sp_whoio shows DiskIO_delta - a metric I introduced to define the real time I/O activity
2010-04-12 (first published: 2010-03-28)
3,793 reads
real time I/O
RE: Presentations/SQL queries
quote: Is using VB and chart controls a big task? I have basic/intermediate skills in VB..is it easy to pick up and utlise with SQL server? I would say No. One thing I like about VB is it's ease of use (once you get used to it). The other thing is that there are countless […]
2003-07-10
1 reads
RE: Launcing DTS packages from Stored Procedures
Thanks Allen, I can Execute the package at a command prompt, but I can't execute the xp_cmdshell from my SP. I should have access to it since I am a Systemadmin. However, I can execute xp_cmdshell from the query analyzer, but not my SP from the database I am working out of. Any suggestions on […]
2003-07-09
RE: Joins
If possible can you post some of the data and structure Suggestion: replace the word WHERE with AND, and check if it makes any difference. Which SQL(7,2000)
2003-07-09
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers