tsql - Are indexes on temporary tables deleted when the table is deleted? -

-

would following sql remove index - or have removed separately?

create table #tbl (field int)  create nonclustered index idx on #tbl (field)  drop table #tbl

yes are. can search in mssql create index article said there:

"indexes can created on temporary table. when table dropped or session ends, indexes , triggers dropped."


Comments

Post a Comment

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

-
i'm working on installer (using wise installer, older version 1999). i'm creating shortcut in programs group exe. i'm creating shortcut on desktop. if install run admin account, create shortcut on common desktop , common program group (i.e., read hkey_local_machine\explorer\shellfor users). if it's installed nonadmin account, install hkey_current_user's desktop , program group. behavior install on: xp nonadmin - desktop , program shortcuts install ok. vista admin - desktop & program shortcuts install ok. vista non-admin, uac off - desktop shortcut installs, program shortcut not . however, program group folder they're supposed installed does created. at end of install, launch program group has shorcut. launches in of above. can manually drag shortcut folder , works fine. i'm bloody baffled. i've tried installing other commercial apps (opera, foxit, firefox) firefox install under nonadmin (and if select other program files,...
Read more

c# - Setting Server Bindings of IIS 6.0 Programmatically -

-
i'm trying set installer register web site. currently, i've got creating application pool , web site under windows server 2003. unfortunately, whenever try modify serverbindings property set ip address, throws exception @ me. first tried because documentation here told me http://msdn.microsoft.com/en-us/library/ms525712%28vs.90%29.aspx . i'm using vb.net, c# answers okay need switch on using c# anyway. siterootde.properties.item("serverbindings").item(0) = "<address>" this throws argumentoutofrangeexception. checked it, , server bindings of size 0. when tried create new entry in list this: siterootde.properties.item("serverbindings").add("<address>") i comexception when try that. i looked @ registered property keys, , serverbindings found. however, when create web site through iis, generates serverbindings correctly , can see it. what need serverbindings appear? edit: moved code on c# , tried it. seems re...
Read more

What do you think are the useless tags in HTML? -

-
as moving on html5, there tags hold least importance did in past.for example <dl> defination list, dont remember last time used tag. and not this, there tags have better , more efficient versions or clear redundancy <strong> , <b> , <basefont> , <font> etc. in opinion, tags developer can live out with?, , tags can ignored? because have better version. it suggested make answer, here excellent page discusses tags , attributes should avoided in html5 pages, , why, though doesn't include elements blink tag. http://www.html-5.com/avoid/
Read more