Viewing 15 posts - 3,826 through 3,840 (of 7,164 total)
I'll agree it is confusing. The article uses "SSDT" to refer to the whole product, including the SSIS development tools, however what they really mean when they say "target" is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 8, 2012 at 6:02 am
Very well done. I especially like the comparison table you produced. I have plans to refer some developers to read this article as the misuse of Table Variables is rampant...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 8, 2012 at 5:38 am
inHouseDBA (6/7/2012)
Few more questions about Stats:
1.How about replacing or creating useful statistics from _WA_Sys_ auto created system stats?
Is it recommended to replace an old auto stat (_WA_Sys_) with...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 8, 2012 at 5:08 am
Yes. Any auto created or manually created column stats.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 7:23 pm
inHouseDBA (6/7/2012)
Thanks, so by running ...UPDATE STATISTICS ? WITH FULLSCAN, COLUMNS;.. it will also update Columns in heap tables as well, right?
If the heap has column-stats on it, yes, it...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 5:30 pm
How is prototyping progressing?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 4:37 pm
In case anyone else finds this link in the future the download is available here:
Microsoft SQL Server 2012 Feature Pack > Microsoft SQL Server 2012 Upgrade Advisor
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 4:33 pm
You're welcome.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 1:46 pm
Permissions Required to Run SQL Server Profiler
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 1:43 pm
SQLCrazyCertified (6/7/2012)
opc.three (6/7/2012)
jitendra.padhiyar (6/7/2012)
You are correct that clustering can be used. And I said clustering will ensure hardware availability, but its not 100% DR, thats why I said clustering alone...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 1:02 pm
jitendra.padhiyar (6/7/2012)
You are correct that clustering can be used. And I said clustering will ensure hardware availability, but its not 100% DR, thats why I said clustering alone can not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 12:29 pm
jitendra.padhiyar (6/7/2012)
SQLCrazyCertified (6/7/2012)
opc.three
"If truly looking for DR then you want to look into Log Shipping, Mirroring or Clustering."
Hi opc.three, I just want to make sure something.....Is it 100%...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 12:04 pm
Eugene-928407 (5/30/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 10:00 am
Brandie Tarvin (6/7/2012)
opc.three (6/7/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 9:43 am
jitendra.padhiyar (6/7/2012)
opc.three (6/6/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2012 at 9:03 am
Viewing 15 posts - 3,826 through 3,840 (of 7,164 total)