TextImage_On option bit for user-defined filegroup in SQL Server -


i created 2 tables this

create table t1 (      [c1] varchar(max),      [c2] int ) on [primary]  create table t2 (      [c1] varchar(max),      [c2] int ) on [primary] textimage_on [myfilegroup]

and inserted them same data unable find how different are. i'd know bit or flag value set on second table tell sql server 1 or more of columns being stored on [myfilegroup] , rest on default storage.

any helpful idea appreciated. thanks!

prior sql server 2005 there special iam chain dedicated lob pages, starting 2005 there allocation units contain information. can read more on here: inside storage engine: iam pages, iam chains, , allocation units

you can use script this:

select object_name(p.object_id) obj_name,         --fg.data_space_id,        fg.name,        --fg.type_desc,        au.* sys.partitions p inner join sys.allocation_units au          on au.container_id = p.hobt_id       inner join sys.filegroups fg          on fg.data_space_id = au.data_space_id  fg.name = 'myfilegroup'       -- , p.object_id = object_id('t2');

to see page types belonging filegroup (this code shows aggregated information per object per page type)

and can detailed (per page) information joinig code sys.dm_db_database_page_allocations() (of course passing in db_id() , object_id() limit rows returned)


Comments

Post a Comment

Popular posts from this blog

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -

what arrayindexoutofboundsexception mean , how rid of it? here code sample triggers exception: string[] name = {"tom", "dick", "harry"}; for(int = 0; i<=name.length; i++) { system.out.print(name[i] +'\n'); } your first port of call should documentation explains reasonably clearly: thrown indicate array has been accessed illegal index. index either negative or greater or equal size of array. so example: int[] array = new int[5]; int boom = array[10]; // throws exception as how avoid it... um, don't that. careful array indexes. one problem people run thinking arrays 1-indexed, e.g. int[] array = new int[5]; // ... populate array here ... (int index = 1; index <= array.length; index++) { system.out.println(array[index]); } that miss out first element (index 0) , throw exception when index 5. valid indexes here 0-4 inclusive. correct, idiomatic for statement here be: for (int index = 0; index <...
Read more