Viewing 15 posts - 15,856 through 15,870 (of 22,211 total)
It could be compile time or it could be a question of data caching or it could be a combination of both.
Usually compile times are pretty benign unless the query...
February 4, 2010 at 6:56 am
If you don't have your clients running regular database backups... you should get on that right away, for all your clients.
February 4, 2010 at 6:55 am
Mostly, believe it or not, these are technical questions, they're business questions. Ask your business how much data loss they're willing to put up with? That will begin to fill...
February 4, 2010 at 6:51 am
Tuning Advisor, assuming it works correctly, and that's a huge assumption, will only suggest indexes for you. Indexes are not necessarily the problem. You need to gather performance metrics to...
February 4, 2010 at 6:49 am
I'm not so sure it's that bad. I like to think of myself as reasonable successful in this field and competent at my job. I would make the claim to...
February 4, 2010 at 6:27 am
You have a lot of stuff in the query that's going to lead to table scans. For example:
AND PAYCODENAME LIKE '%' + @PAYCODE + '%'
Will only allow for table scans....
February 4, 2010 at 6:04 am
tvantonder-992012 (2/3/2010)
Msg 208, Level 16, State...
February 4, 2010 at 5:58 am
I didn't think to ask that.
February 3, 2010 at 12:24 pm
If it's doing no work at all, but using up all the memory on the system... I'd contact Microsoft. Open a PSS call or at least put it in Connect...
February 3, 2010 at 9:33 am
Don't use a staging table, instead use SSIS to do the import and that way you can break down the records on the fly.
February 3, 2010 at 9:31 am
GilaMonster (2/3/2010)
Um....
MySQL has pretty similar concepts too. I think I'll just start answering every question with a MySQL answer. After all, what's the difference really?
February 3, 2010 at 7:42 am
tvantonder-992012 (2/3/2010)
February 3, 2010 at 7:08 am
No, I'm still not sure what's up.
One difference is I ran it on 2008. But there's little reason it should be different.
February 3, 2010 at 6:50 am
I think you need to further clarify what types of options you're looking for. Do you mean three different ways to rebuild an index? Do you mean three parameters you...
February 2, 2010 at 7:24 am
Maybe I missed a step or something, but I just tested your script against a test database using SQL Agent and it ran without errors.
February 2, 2010 at 7:00 am
Viewing 15 posts - 15,856 through 15,870 (of 22,211 total)