Viewing 15 posts - 3,796 through 3,810 (of 7,168 total)
happycat59 (6/16/2012)
opc.three (6/15/2012)
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...
June 16, 2012 at 8:19 am
Jeff Moden (6/15/2012)
June 15, 2012 at 7:08 pm
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...
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...
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...
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...
June 14, 2012 at 11:44 pm
This may help answer your question:
http://stackoverflow.com/questions/28952/cpu-utilization-by-database
June 14, 2012 at 11:03 pm
GilaMonster (6/14/2012)
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...
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...
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...
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...
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...
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...
June 13, 2012 at 3:25 pm
Evil Kraig F (6/12/2012)
SueTons (6/12/2012)
June 12, 2012 at 9:46 pm
Viewing 15 posts - 3,796 through 3,810 (of 7,168 total)