Viewing 15 posts - 3,796 through 3,810 (of 7,164 total)
sqldba_newbie (6/15/2012)
opc.three (6/14/2012)
This may help answer your question:http://stackoverflow.com/questions/28952/cpu-utilization-by-database
Thanks. Does it matter what is my mAXDOP?
No. In Brent's query, what you're calculating is total elapsed time. The results will not tell...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 15, 2012 at 8:58 am
akin.akinwumi (6/15/2012)
opc.three (6/15/2012)
akin.akinwumi (6/15/2012)
Copy your linked server query into an 'Execute SQL' task in SSIS. That way you get the best of both worlds!;-)
In my opinion that is actually the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 15, 2012 at 8:05 am
akin.akinwumi (6/15/2012)
Copy your linked server query into an 'Execute SQL' task in SSIS. That way you get the best of both worlds!;-)
In my opinion that is actually the worst of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 15, 2012 at 7:48 am
Also, in general, an OLE DB destination will be faster than an ADO.NET destination. So, I would switch back to OLE DB and do as happycat suggests and make sure...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2012 at 11:44 pm
This may help answer your question:
http://stackoverflow.com/questions/28952/cpu-utilization-by-database
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2012 at 11:03 pm
GilaMonster (6/14/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2012 at 10:50 am
GilaMonster (6/14/2012)
I would simply recommend staying away from the terms 'internal fragmentation' and 'external fragmentation' entirely as there is no clear definition.
In general I would tend to agree. If presented...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2012 at 10:13 am
Evil Kraig F (6/13/2012)
That is... not how I learned the term Internal Fragmentation.
Gail's point about attaining a definition from the person speaking about fragmentation is very appropriate here. I made...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2012 at 9:44 am
If you consider leaving OLE Automation procs off a benefit, then yes, I agree. Of course, that all falls into whether you have a properly locked down system or...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 14, 2012 at 7:29 am
Jeff Moden (6/13/2012)
Also, why would you recommend using "Database Mail" instead of CDOSysMail?
One of the primary reasons is to make sending email from the database an asynchronous operation. When send...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 13, 2012 at 9:02 pm
If they're in the sentitems view it means they were accepted by the SMTP server. I think the issue will turn out to be somewhere between the SMTP server and...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 13, 2012 at 4:10 pm
Is is safe to assume your using Standard or Enterprise Edition since you said you have SQL Agent running? i.e. that you are not using Express Edition?
If so, then I...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 13, 2012 at 3:25 pm
Evil Kraig F (6/12/2012)
SueTons (6/12/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2012 at 9:46 pm
SueTons (6/12/2012)
opc.three (6/12/2012)
GilaMonster (6/12/2012)
3. Deletes don't cause fragmentation.I thought that deletes were a major cause of internal fragmentation, though not necessarily external fragmentation.
Yes, I second that deleting also cause fragmentation....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2012 at 6:22 pm
Evil Kraig F (6/12/2012)
Nailed by the dupe post as well. Dangit, don't do that.
Dang it! Caught in the churn again. I started my response before you posted the dupe...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 12, 2012 at 1:56 pm
Viewing 15 posts - 3,796 through 3,810 (of 7,164 total)