Viewing 15 posts - 2,911 through 2,925 (of 18,926 total)
Michael Valentine Jones (9/8/2011)
GilaMonster (9/4/2011)
kp_kumar (9/4/2011)
You can reduce the backup time by specifying multiple files instead of single file.
Only if those files are on separate drives (not separate partitions...
September 8, 2011 at 10:02 am
What's the default size of tempdb? That can be set.
I'm not 100% sure here but I really don't think that tempdb is a perfect copy from model.
September 8, 2011 at 10:01 am
Right click on your subreport object, properties, parameters.
September 8, 2011 at 9:59 am
sturner (9/8/2011)
GilaMonster (9/8/2011)
The only way to re-enable an index is to rebuild it, and an index rebuild updates statistics with full scanThe defense rests.
Just not to waste a newly minted...
September 8, 2011 at 9:58 am
Google output parameters
September 8, 2011 at 9:48 am
Tom.Thomson (9/8/2011)
But the behaviour still seems bizarre to me. Why should the loop join hint be taken to imply the (Force Order) option - if I...
September 8, 2011 at 9:46 am
TechnoPeasant (9/8/2011)
"Your priorities for this week are projects A,B&C! We dont know anything about them, have no dates and the...
September 8, 2011 at 9:40 am
chris.mcgowan (9/8/2011)
I love the scptfxr utility in SQL 2000, It made scripting full databases and individual objects easy!
Link to download for us youngsters? Or olders that lost the 2K...
September 8, 2011 at 9:24 am
Alright, let me know how it turns out.
Just a FYI, I've never done a report that didn't lead to a business decision (even trending). I know there's only a...
September 8, 2011 at 9:24 am
Snapshot will allow you to ALWAYS get the correct results with the same speed as nolock.
Also nolock can actually be locked out of some dml operations. It's not a...
September 8, 2011 at 9:07 am
What's up with bug finding these days?
Sounds almost like a treasure hunt :w00t:.
September 8, 2011 at 8:46 am
I would personnally disable the indexes. That way you don't have to bother about keeping the packages in sync with the index mods for tuning or whatknot.
September 8, 2011 at 8:45 am
Use nolock only if management APPROVES getting incorrect reasults. Which they never do.
Change your db to allow snapshop isolation and use that in all your queries & sps.
It increases...
September 8, 2011 at 8:44 am
Viewing 15 posts - 2,911 through 2,925 (of 18,926 total)