Viewing 15 posts - 13,426 through 13,440 (of 22,213 total)
I'm not sure, but I frankly wouldn't worry about it. Perfmon is where you should be collecting that data.
January 31, 2011 at 10:50 am
Brandie Tarvin (1/31/2011)
If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?
I wasn't mean or cruel, but I certainly wasn't diplomatic.
January 31, 2011 at 6:36 am
You're posting in the SQL Server 2005 forum, so you might get answers that don't apply to sQL Server 2000. Just so you know.
I would use a server-side trace. That's...
January 31, 2011 at 6:35 am
Ninja's_RGR'us (1/31/2011)
Am I really smarter than the best MS engineer who had 10 000s of hours to...
January 31, 2011 at 6:30 am
Books Online, the documentation that comes with SQL Server, should be open on your desktop most of the time. It sure is on mine.
After that, you've got here at SSC...
January 31, 2011 at 6:27 am
I was bad. I was very bad. Just had to slap down a poster, couldn't help it. "Hey, I need a complete system design, thanks." Man I hate those.
January 31, 2011 at 6:25 am
I would ditch all the query hints entirely. Using hints you're forcing the optimizer and the query engine to do things your way instead of letting them figure out the...
January 31, 2011 at 6:19 am
I have to say, you're asking for a complete system design on a rather complicated set of requirements, which you haven't completely provided. Many of us are paid to do...
January 31, 2011 at 6:17 am
Another problem is cross-database dependencies. If you have lookup tables in different databases, you can't use declarative referential integrity, foreign keys, to ensure the consistency of the data. You'd have...
January 31, 2011 at 6:13 am
My general approach is a little different than others. I tend to cluster on the most frequently accessed path into the data that is also selective enough to index well....
January 31, 2011 at 6:11 am
There's no magic way to to do it. You're going to have a bunch of work in front of you. The easiest part is creating the blank database. You can...
January 31, 2011 at 6:09 am
Perfmon is measuring the memory used. Task Manager is, I believe, showing you the size of the executable, not the memory allocated for it.
January 31, 2011 at 6:04 am
That's a formatting issue, not a data storage issue. You should deal with that on the client side, not in your database.
January 31, 2011 at 6:00 am
Without using a third party tool, your only option is as described above, a full restore to a different location or a different database and then migrate the tool over.
You...
January 31, 2011 at 5:59 am
Viewing 15 posts - 13,426 through 13,440 (of 22,213 total)