skip to main
|
skip to sidebar
im.lucky.devil
Friday, 9 July 2010
Temporary Tables vs. Table Variables
Temp Table
Table Variable
record transaction logs?
Yes
No
inside transaction scope?
Yes
No
cross execution batch?
Global temp table
No way
support index?
Yes
No
where to store?
Tempdb
Memory
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Categories
ado.net
ajax
Android
asp.net
Azure
C#
code first migration
color
cross-browser
CSRF
css
database
decimal
DHTML
doule
dynamically insert
error
float
framework
HttpModule
HttpWebRequest
Interview
iOS
javascript
Joomla K2
LINQ
mvc
Oracle
page size
performance
preload audio
preload image
preload media
Regular Expression
render
Security
Serialization
SharePoint
SQL
sql server
SSRS
style sheet
T-SQL
tips
Uhuru
WCF
Web
web 2.0
web service
Windows Phone
WinForm
WTF
XHTML
XML
XmlSerialization
XSS
Yahoo
Tech Guru's Site
Artech
Cocoa China 苹果开发中文站
iCodeBlog
Objective-C Beginner's Guide
SharePoint guru web
Terry Lee's Tech Space
tonyqus.cn
像Mario一样飞 (moblie web dev site)
Blog Archive
►
2013
(5)
►
October
(2)
►
August
(1)
►
July
(1)
►
February
(1)
►
2012
(5)
►
September
(2)
►
April
(1)
►
March
(1)
►
January
(1)
►
2011
(6)
►
October
(3)
►
September
(1)
►
June
(1)
►
February
(1)
▼
2010
(15)
▼
July
(4)
Developing on SharePoint 2010 (Day 2)
Oracle Procedures (version 11.1)
Temporary Tables vs. Table Variables
Developing on SharePoint 2010 (Day 1)
►
May
(1)
►
April
(1)
►
March
(2)
►
February
(3)
►
January
(4)
►
2009
(11)
►
May
(4)
►
April
(3)
►
February
(4)
►
2008
(26)
►
December
(5)
►
November
(2)
►
October
(6)
►
July
(4)
►
June
(1)
►
April
(1)
►
March
(2)
►
February
(5)
About Me
im.lucky.devil
Sydney, NSW, Australia
Since sometime, there's an expiration date on everything. Saury will be expired, canned meat will be expired, and even tin foil will be expired. I can't help wondering - is there anything on this planet that won't expire...
不知道从什么时候开始,在每一样东西上面都有一个日子,秋刀鱼会过期,肉罐头会过期,连保鲜纸都会过期,我开始怀疑,在这个世界上,还有什么东西是不会过期的?...
View my complete profile
No comments:
Post a Comment