天天向上
日常的一些小笔记
博文
(2014-08-03 09:15:54)
surrogatekey,uniqueidentifier,notfromtheapplicationdataitself[阅读全文]
(2014-07-28 17:05:11)
don'tuse*inthequery(*isanti-patterninquery,whichwillcreatemuchworkfortheserver)
don'tomitcolumnlistininsertion(thinkwhatifanewcolumnwillbeaddedlater)
...
AdhocisaLatinphrasemeaning"forthis".Itgenerallysignifiesasolutiondesignedforaspecificproblemortask,non-generalizable,andnotintendedtobeabletobeadaptedtootherpurposes.Commonexamplesareorganizations,committees,andcommissionscr...[阅读全文]
don'tomitcolumnlistininsertion(thinkwhatifanewcolumnwillbeaddedlater)
...
AdhocisaLatinphrasemeaning"forthis".Itgenerallysignifiesasolutiondesignedforaspecificproblemortask,non-generalizable,andnotintendedtobeabletobeadaptedtootherpurposes.Commonexamplesareorganizations,committees,andcommissionscr...[阅读全文]
(2014-07-28 09:33:04)
sp_help
sp_helpindex
sp_helptext
sysobjects
OBJECT_ID()
syscomments
sys.sql_modules
GO
ONLYinSSMS,abatchseparator/terminator,youcanchangeittowhateveryouwant.
ItisusedtogroupSQLcommandsintobatcheswhicharesenttotheservertogether.
CREATEDEFAULT,CREATEFUNCTION,CREATEPROCEDURE,CREATERULE,CREATETRIGGER,andCREATEVIEWstatementscannotbecombinedwithotherstatementsinab...[阅读全文]
sp_helpindex
sp_helptext
sysobjects
OBJECT_ID()
syscomments
sys.sql_modules
GO
ONLYinSSMS,abatchseparator/terminator,youcanchangeittowhateveryouwant.
ItisusedtogroupSQLcommandsintobatcheswhicharesenttotheservertogether.
CREATEDEFAULT,CREATEFUNCTION,CREATEPROCEDURE,CREATERULE,CREATETRIGGER,andCREATEVIEWstatementscannotbecombinedwithotherstatementsinab...[阅读全文]
(2014-07-28 08:54:21)
Wordsstartingwithconsonant:
movetheconsonanttotheendoftheword,thenadd'ay'attheend
the-->ethay,cat-->atcay
Wordsstartingwithvowel:
add'way'attheend
eat-->eatway,and-->andway
Haveaniceday!
-->Avehayawayicenayayday!
Areyoulookingforajob?
-->Arewayouyayookinglayorfayawayobjay?
Oinkoink
-->Oinkwayoinkway
movetheconsonanttotheendoftheword,thenadd'ay'attheend
the-->ethay,cat-->atcay
Wordsstartingwithvowel:
add'way'attheend
eat-->eatway,and-->andway
Haveaniceday!
-->Avehayawayicenayayday!
Areyoulookingforajob?
-->Arewayouyayookinglayorfayawayobjay?
Oinkoink
-->Oinkwayoinkway
(2014-07-28 08:20:38)
Owneristhecreater.
Useristheuseraccountunderacertaindb.
schemaisacontainerfororganizingtheobjects.
schemasvsusers
dbo--1.dbowner;2.useraccount:dbo;3.schema:dbo
dbo.tblPerson--heredboisreferredasthe'SCHEMAdbo',not'userdbo'or'ownerdbo'
proofschema.tblxxx:
Sincetheobjectsarenottiedtoanyuseraccounts,youdonothavetoworryaboutchangingtheownerofobjectswhenanaccountistoberemoved...[阅读全文]
Useristheuseraccountunderacertaindb.
schemaisacontainerfororganizingtheobjects.
schemasvsusers
dbo--1.dbowner;2.useraccount:dbo;3.schema:dbo
dbo.tblPerson--heredboisreferredasthe'SCHEMAdbo',not'userdbo'or'ownerdbo'
proofschema.tblxxx:
Sincetheobjectsarenottiedtoanyuseraccounts,youdonothavetoworryaboutchangingtheownerofobjectswhenanaccountistoberemoved...[阅读全文]
(2014-07-22 21:30:01)
SSISDBcatalog
deployanSSISprojectintoSSISDB(3ways)
datatools-BIDS(inearlyversion)
DTS(inearlierversion)-->SSIS(08orlaterversion)(tasks/importorexport...)
connectiontype(OLEDB,ODBC)
stagingtable
Hibernateinsert
bulkinsertwithbulkadmin
con:
popularinlegacysystem,SP'slogicisstillonDBitself.
SPincreasesthedifficultyofdeploymentandmaintenance,causeshigercoupling....[阅读全文]
deployanSSISprojectintoSSISDB(3ways)
datatools-BIDS(inearlyversion)
DTS(inearlierversion)-->SSIS(08orlaterversion)(tasks/importorexport...)
connectiontype(OLEDB,ODBC)
stagingtable
Hibernateinsert
bulkinsertwithbulkadmin
con:
popularinlegacysystem,SP'slogicisstillonDBitself.
SPincreasesthedifficultyofdeploymentandmaintenance,causeshigercoupling....[阅读全文]
(2014-07-22 07:54:49)
文档管理文档、电子表格、图形和影象扫描文档的存储、分类和检索。每个文本具有一个类似于索引卡的记录，记录了诸如作者、文档描述、建立日期和使用的应用程序类型之类的信息。这些文档一般归档在较便宜的磁带上，必要时归档在可读写的光盘上。[阅读全文]
(2014-07-20 21:23:34)
BuildHadoopinAzure.HDInsightmakesApacheHadoopavailableasaserviceinthecloud.
[阅读全文]
[阅读全文]
(2014-07-19 09:32:50)
IPO,InitialPublicOffering,acorporation'sfirstoffertosellstocktothepublic
Cloudera(halfboughtbyIntel)>MapR(recentlyfundedbyGoogleCapitalandQualcomm)>Hortonworks(fundedbyGoogleVenture)??
GoogleCapital:biggerfundforlatestagestartups
GoogleVenture:smallerfundforearlystagestartups
AWS
EC2AmazonElasticCloudCompute,providesscalablevirtualprivateserversusingXen.
S3AmazonSimpleStora...[阅读全文]
Cloudera(halfboughtbyIntel)>MapR(recentlyfundedbyGoogleCapitalandQualcomm)>Hortonworks(fundedbyGoogleVenture)??
GoogleCapital:biggerfundforlatestagestartups
GoogleVenture:smallerfundforearlystagestartups
AWS
EC2AmazonElasticCloudCompute,providesscalablevirtualprivateserversusingXen.
S3AmazonSimpleStora...[阅读全文]
(2014-07-18 07:24:35)
normalization/denormaliztion
fact/dimension/base
staging
cursor(performacekiller)
CTE
WITH
Hierarchicaldata
HierarchyIDdatatype
recursivetree
windowfunction
analyticalfunction
aggregatefunction
rankingfunction
performancetuning(SETNOCOUNTON)
randomdataordatasample(TOPn,TABLESAMPLE(nROWS),ORDERBYNEWID(),CHECKSUM(NEWID())
CASE
IDENTITYA...[阅读全文]
fact/dimension/base
staging
cursor(performacekiller)
CTE
WITH
Hierarchicaldata
HierarchyIDdatatype
recursivetree
windowfunction
analyticalfunction
aggregatefunction
rankingfunction
performancetuning(SETNOCOUNTON)
randomdataordatasample(TOPn,TABLESAMPLE(nROWS),ORDERBYNEWID(),CHECKSUM(NEWID())
CASE
IDENTITYA...[阅读全文]
