Viewing 15 posts - 13,981 through 13,995 (of 22,211 total)
Back to the original purpose of this thread, my only response to this, once the clarification was in, is WTF?!?
October 29, 2010 at 7:29 am
SELECT * FROM Table
This query will simply scan the table. So, performance is strictly up to the hardware. How fast are your disks? How fast is your CPU? That's...
October 29, 2010 at 7:23 am
There just isn't any magic way to kill a process. If you know where the problem is, I'd concentrate on fixing it. If a transaction is opened and running, when...
October 29, 2010 at 7:07 am
For no cost, you can install PowerShell and put that to work, again using SMO. A script to generate all database objects would only be about 30 lines. I have...
October 29, 2010 at 7:05 am
You're really naming all your columns, Col1, col2... Troubleshooting and developing against that should be a lot of fun.
What kind of query are you trying to run? You don't list...
October 29, 2010 at 6:59 am
Yep, Marco has nailed it. A trace runs on an instance. You can filter the trace.
I'm a bit confused over what you're trying to do. You talk about all databases...
October 29, 2010 at 6:56 am
Can you please show what you've tried that hasn't worked. We're more than willing to help. But, we're not doing your homework for you.
October 29, 2010 at 6:53 am
There are a number of cases, certainly not a majority by any stretch of the imagination, where performance is worse in 2008 than it is in 2000. Usually this is...
October 29, 2010 at 6:52 am
Hey everyone. I'm positive one or more of you can help this guy
October 29, 2010 at 6:46 am
I haven't a clue about this, so I'm going to call in some reinforcements. Stand by.
October 29, 2010 at 6:44 am
Another option to creating an index is to create statistics. However, neither index nor statistics can be created and then automatically dropped. Any create requires a subsequent drop action on...
October 29, 2010 at 6:43 am
Assuming my family history, location, and birth would be roughly equivalent, unfortunately, farmer. I'm actually part of the first generation in my family going back 200 years on my fathers...
October 29, 2010 at 5:47 am
Jeff Moden (10/28/2010)
Brandie Tarvin (10/28/2010)
Now I'm obsessing about...
October 29, 2010 at 5:26 am
GilaMonster (10/28/2010)
Grant Fritchey (10/28/2010)
Yeah, I stumble over the word "statistics" badly enough without having a mouth full of sugar.
At least you didn't take on an hour and a half presentation...
October 29, 2010 at 5:20 am
Luke L (10/28/2010)
Grant Fritchey (10/28/2010)
Brandie Tarvin (10/28/2010)
Waving to Grant across the interwebs while listening to him present on execution plans!
Oh, that was you? Sorry I didn't wave back. Man, I...
October 29, 2010 at 5:18 am
Viewing 15 posts - 13,981 through 13,995 (of 22,211 total)