SQL Server Indexing -

-

i trying understand going on create index internally. when create nonclustered index shows insert in execution plan when query test. 

declare @sqltext varbinary(128) select @sqltext = sql_handle sys.sysprocesses s spid = 73 --73 process creating index select text sys.dm_exec_sql_text(@sqltext) go

show:

insert [dbo].[tbl] select * [dbo].[tbl] option (maxdop 1)

this consistent in execution plan. info appreciated.

this lack of knowledge on indexes, difference 4 months of experience makes! :)

the index creation cause writes index insert leafs needed.


Comments

Post a Comment

Popular posts from this blog

php - How to build a web site which gives a sub-domain dynamically to every registered user? -

-
possible duplicate: create subdomain upon user registration suppose have site, , wish give sub-domain each registered users. site, http://site.com/ . and test-user user registered on site, , site wants make sub-domain user. like http://test-user.site.com . like http://test-user1.site.com test-user1. i hope understood requirement. how can create sub-domain using sites back-end or dynamically while registering? make dns record bring * requests site ip. set web server handle * requests (thanks @animuson mentioning) check $_server['http_host'] against database. profit!!!
Read more

c# - Add item to Generic List / Collection using reflection -

-
i want add item generic list using reflection. in method "dosomething", trying finish following line, pi.propertytype.getmethod("add").invoke(??????) but getting different kinds of error. below complete code public class mybaseclass { public int vechicleid { get; set; } } public class car:mybaseclass { public string make { get; set; } } public class bike : mybaseclass { public int cc { get; set; } } public class main { public string agencyname { get; set; } public mybasecollection<car> lstcar {get;set;} public void dosomething() { propertyinfo[] p =this.gettype().getproperties(); foreach (propertyinfo pi in p) { if (pi.propertytype.name.contains("mybasecollection")) { //cln contains list<car> ienumerable<mybaseclass> cln = pi.getvalue(this, null) ienumerable<mybaseclass>; ...
Read more