Lun

hi… i new ssrs , don’t understand behavior i'm observing on report (“extract”)   using report code selectively accumulate amount.   the intention accumulate single value of amtamt per icn, in effect eliminating duplicate amtamt per icn. the expression under “function return” calls report-code function accumulate amtamt when column not zero; ”code.amounttotal” seems incremented when function not called.   the same behavior observed if expression modified call code.addamount(0) instead of returning 0.0. input/feedbacks? desdeaqui, as know, process steps of iif function is: 1. calculate expression , replace field expression actual value. 2.   return relevant value according condition logic. why amount value accumulating on each row, root cause expression code.addamountbtyval(fields!amt.value) occurring in iif function. demo illustrate avoid problem successfully. thanks, bill lu bill lu technet community support

msdn resources little unclear on this: if variable-length data type column (e.g. varchar(255)) used in clustered index, how space should used calculate size of index - average length of data in column or max length? varchar columns allocate amount of space needed store the current data (plus 2 bytes overhead). therefore, best estimation use average length of data in column (plus 2 bytes overhead). thanks mirek   SQL Server  >  SQL Server Database Engine

i created style listbox when item clicked not show has been selected.  used blend create style , when using vsm states looks fine.  unfortunately, when it's running states don't work. i did have problems getting style working @ first when using datatemplate thought creating style better.  can take , let me know if there's missed.  feel there's small can't seem put finger on it. <phone:phoneapplicationpage.resources> <style x:key="gamelistboxitemstyle" targettype="listboxitem"> <setter property="background" value="transparent"/> <setter property="borderthickness" value="0"/> <setter property="borderbrush" value="transparent"/> <setter property="padding" value="0"/> <setter property="horizontalcontentalignment" value="left"/&g

i trying find way have continuously animate.  example, have circular wheel-like images want have continuously rotate.  can set storyboard start on load and rotate 360 degrees @ speed, want these keep rotating time.  how approach this?  thanks in advance. on doubleanimation, add repeatbehavior="forever" an example: http://www.wynapse.com/silverlight/silverlight_rolling_gear_animation.aspx the xaml expanded near bottom. -dave Silverlight  >  Programming Silverlight with JavaScript

hello, i've been fighting while now.  can't version control start anymore on tfs 2008 server.  it's single tier setup.  here error when start web service.  suggestions appreciated. tf53010: following error has occurred in team foundation component or extension: date (utc): 3/4/2009 5:01:26 pm machine: test2003svrstd application domain: /lm/w3svc/1019103864/root/versioncontrol-3-128806596852128750 assembly: microsoft.teamfoundation.common, version=9.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a; v2.0.50727 process details: process name: w3wp process id: 3700 thread id: 4032 account name: test2003svrstd\administrator detailed message: tf30059: fatal error while initializing web service web request details url: http://tfsdata.awhere.com:8080/versioncontrol/v1.0/repository.asmx [method: post] user agent: team foundation 9.0.21022.8, (webaccess 9.0.2889) headers: content-length=319&content-type=application%2fsoap%2bxml%3b+charset%3dutf

we using sql 2008 , our company has signed contract net work company of time change network admins .we have no problem long can separate tasks of net admin , dba. there way achieve this?in fact want sure domain admin never can touch databases. --yousef mr. mike hotek gives answer regarding in following tread:- http://social.msdn.microsoft.com/forums/en-sg/sqlsecurity/thread/1bb5a3f3-d2f5-44ee-b32e-80c1f6df7c45   we can create login-trigger restrict domain-admin log-on on sql-server. can diable/delete trigger , can open database.   --------------------------------- devender bijania SQL Server  >  SQL Server Security

i error when try add new\blank mdf project in visual web developer:   connections sql server files (*.mdf) requires sql server express 2005 function properly. please verify installation of component or download url: http://go.microsoft.com/fwlink/?linkid=49251   i've googled *** out of subject , i've found multiple forums different answers, of open connect server dialogue , in blank field type: "sqlexpress" or "sqlserverexpress". niether of these work, of these forums vwd2005, i'm using vwd2008 , sql server express 2005. have ideas? i'm running both on vista laptop. woot! ok, computer name worked connection , test successful, still same error when try create new database in project. ideas?   SQL Server  >  SQL Server Setup & Upgrade

hello accessing wcf service , getting error error occurred while trying make request uri 'http://localhost:10201/stockservice'. due attempting access service in cross-domain way without proper cross-domain policy in place, or policy unsuitable soap services. may need contact owner of service publish cross-domain policy file , ensure allows soap-related http headers sent. please see inner exception more details. see file   waht cross domain why access poilcy file for... how give every 1 access not metter cross domain or in domain  < access-policy> < cross-domain-access> < policy> < allow-from http-request-headers="*"> < domain uri="*"/> < grant-to> < resource path="/" include-subpaths="true"/>   hi, this article can you: http://msdn.microsoft.com/en-us/library/cc197955(vs.95).aspx to avoid cross-domain issues put clientaccesspolicy.xml and/or crossdomain.xml in r

i'm prototyping windows store app with augmented reality should work inside room. i've had played long time ago slartoolkit windows phone, has not been updated windows 8. i've done research, there lot of cool libraries, couldn't find 1 works windows store apps. use indoor, geo apis cannot used (gart https://gart.codeplex.com/ ), need uses tags artoolkit did. i know there qualcomm's vuforia https://developer.qualcomm.com/mobile-development/mobile-technologies/augmented-reality , slartoolkit, metaio http://www.metaio.com/ , , more, couldn't find 1 worked windows store apps. do know any? thanks, juanma juan manuel servera twitter: @jmservera mi blog: http://jmservera.com Únete al grupo de wp7 en linkedin mcpd wp7 developer - mcts sharepoint 2010 application development hi juan, i'm not familiar turnkey ar toolkits, sensor system there apps use , gets better windows 8.1. else in community may be able provide more information third

i have been developing tabular model  on sql server 2016 few months now, of last week, have not been able access tables properties screen 1 table. some details there total of 13 tables in tabular model, coming single data source. the data source sql server using single connection using microsoft ole db provider sql server i can view table properties every table besides one. the table can not view table properties largest table in model, @ 800,000 rows there number of calculated columns , measures on table it accessing view data source recently few columns have been added view, none have been removed. i receiving connection timeout error, increased initialization connect timeout attribute connection until received new error new error code: cannot connect  the data source table "factstop". make sure data source available. if contact microsoft support error, provide following message:  cannot connect  the data source table "factstop". make sure data

hello all,     finding top count of 15 manufactures based below query. with set agg as extract (topcount(  crossjoin([product].[manufacturer].[manufacturer].members, [wholesaler].[wholesaler group].&[grupo cofares],{[product].[market segment1].&[dermocosmetica],[product].[market segment1].&[accesorios sanitarios]}) ,   15, [measures].[indirect ex-mnf sales value]),[product].[manufacturer]) however might 14 manuacturers because can have manufacturer repeating because of multiple market segments. so in case need top 16 or on until exact 15 manufacterer's. can 1 suggest? thank you!! regards, bharath hi bharath, providing able make rough estimations, maybe can live following  quick  , easy  solution:   you may wrap set head(,15) function if take topcount(,x) large enough.  head( extract (topcount( ..... , 50 , ..... .....[manufacturer]) , 15 ) philip,

hi, when tabular support inner joins in direct query mode power bi able now? the tabular engine in 2016 supports now. there not way of setting through ui - have edit json script (see  http://www.kasperonbi.com/improve-performance-with-directquery-by-using-inner-joins/ ) http://darren.gosbell.com - please mark correct answers SQL Server  >  SQL Server Analysis Services

anyone pls help.... problem how pass data asp.net silverlight without refresh page?? have 1 .aspx page contain silverlight application, when pass data .aspx silverlight application, silverlight application refresh, .aspx page still remain same. pls me...thanks!! http://forums.silverlight.net/forums/t/87279.aspx also, can send data silverlight application on html bringe Silverlight  >  Programming Silverlight with .NET – General

i have grid object populate bunch of labels , maybe images. now want grid lines white , dashed way can figure out how adding rectangle each cell , giving strokedash array.. is there better way this? hi. describe recommended way mentioned in documentation (but borders instead of rectangles). there property showgridlines, it's explicitly meant design-time purposes. details read  this . Silverlight  >  Programming Silverlight with .NET – General

  i install sql express silently.   then try following   -s .\instance -q "sp_attach_db 'attach_as_name', 'c:\program files\app_name\sqldata\app_db.mdf'"   this works...sometimes. many times wll permissions error on folder "c:\program files\app_name". if go , give "everyone" "full permission" folder...it works fine.   my questions are: 1) system users need access (and @ level) folder attach? because giving full access bad.   2) there better method deploying populated database application this? sql service account needs modify privilege on "c:\program files\app_name\sqldata\" path. if running in local system account make sure system or nt authority \ system has modify privilege on path SQL Server  >  SQL Serv

i want migrate sql server 2008 instance along reporting services, integration services, etc. domain domain b. steps for doing this? thanks joe hello,   please see following link: http://ask.sqlteam.com/questions/1742/how-to-move-sql-2005-server-from-one-domain-into-another please tell sql server features have installed.   hope helps,   regards,   alberto morillo sqlcoffee.com SQL Server  >  SQL Server Setup & Upgrade

looks pretty straight forward hasnt been working :( trying set connection string (for ado.net destination)from variable in xml config file simple data flow task. gave dev server connection string @ design time , itg server in xml file. moment set expression connection string design time value disappears , not able running.  i have tried usual steps- (have more basic skills in ssis).. missing out .. should check.. please make christmas solving me .. !!!  hemachandra : <abbr class="affil"></abbr> please remove 1 http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/911e5920-b195-43d8-a28d-323d34eea828 up-to-date arthur my blog SQL Server  >  SQL Server Integration Services

i hope proper forum post hardware/best pratice question. we have 2000 sql 2005 on hp dl 585 has own msa30 drive shelf. has own 4 channel scsi pcix card think 512mb of cache.  msa30 filled 14 u320 hd.  have second msa 30 comming. db size 334gb. have set of tables contain data compiled , set of tables contain post compiled. precompiled data takes of space. here is question. 1. better have a filegroups multiple data files spread on both msa30's or 2 large files 1 on each drive tray. please post question " sql server database engine " quick response.   thanks, peter SQL Server  >  SQL Server Setup & Upgrade

hi all, i have query related customization of tfs web access  " home page" live tiles. i customize web access page such live tiles eg : product backlog or build information details displayed under 'team favourites'  as create team project.   i elaborate it-  usually these tiles appear after query , right click , add team favorites in web access. how can web access live tiles customized automatically populated on home page on creation of team project. do need modify process template or write sql query?  thanks, chandana s   hi chandana, as mentioned in post, can add tiles/chart homepage of team project via pin queries in team favorites. see article for more information. far know, seems it's unavailable such customization team web access when create team project. best regards, we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make co

hi, i have textblock, textbox , descriptionviewer. i want use validation. when textbox in invalid state ( invalidunfocused, invalidfocused ) want change color of descriptionviewer , textblock. when textbo in valid state, want restore them original colors. how do it?   thanks. janiv ratson.   anyone? thanks. Silverlight  >  Silverlight Controls and Silverlight Toolkit

hi all, i discovered powerpivot case-insensitive, quite big problem me. discussion of found far here:  http://dennyglee.com/2010/06/18/powerpivot-you-are-so-insensitive-case-that-is/  . that didn't answer question though, possible change behaviour , make case sensitive? the reason it's problem me have column (from external data source) used id in relationship, contains string of random characters. if happens 2 entries have id differs case of letter, blows up. more precisely, can no longer import data table column used pk, because not unique. thanks comments, jurgis powerpivot automatically picks collation based on language working on. collation determines case sensitive nature. default collation's case insensitive. don't see way of changing collation. thanks, deva [msft] blog: http://powerpivot.spaces.live.com/ SQL Server  > 

hi if want compare datetime vs specific time should do? i.e.   startdatetime                                 specific  time      2015-10-12 00:03:19:020                16:23:00 i want compare time in startdatetime coloum vs specific time i.e. 16:23 . please me!           katherine xiong thnaks reply i convert startdatetime to (dt_dbtime) after want calculate time difference. how can it? i.e want calculate 2 (dt_dbtime) columns without date ==> (16:23:00)-(00:03:19) thanks of fast replies katherine xiong thnaks reply i convert startdatetime to (dt_dbtime) after want calculate time difference. how can it? i.e want calculate 2 (dt_dbtime) columns without date ==> (16:23:00)-(00:03:19) thanks of fast replies if wanted find out time difference between 2 time values can use this datediff("s",(dt_dbtimestamp) "16:23:00",(dt_dbtimestamp) "00:03:19") or specifying column in place of values

hello, i have data set location (address, city, state) information, automated cleaned location (cleanedaddress, cleanedcity, cleanedstate). wanted compare each row in fuzzy manner come similarity score. not want have each row compared entire index of data in source table. any suggestions on how this? there's no tool in ssis so. you'll have use script component compute using whatever algorithm wish.  did quick search , found one: compute levenshtein distance .  don't know if it's reputable or not. you push whole table sql , use soundex . SQL Server  >  SQL Server Integration Services

hi is idea add indexes replicated database. replicated database being used data ware house application data database.     regards soumyajeet absolutely!  one of main strengths of replication ability have reporting-specific indexes on replicated database don't need on source database. SQL Server  >  SQL Server Replication

hello everyone! i'm having basic problem calculating measure not rolling correctly. essence (borrowed):  [total sold] = [measures].[quantity] * [measures].[unit price] total product             30         200         6000-->should 3000    product a                  10         100         1000    product b                  20         100         2000 i can compute correct total if define custom dimension member correct solve_order. however, want correct results in excel, , don't have control on excel's queries. thanks! original place question asked: http://www.eggheadcafe.com/forumarchives/sqlserverolap/dec2005/post25056620.asp hi the problem experiencing formula being applied @ total level. assume want have formula applied @ product level , higher levels sum of children. to have couple of options: add new named calculation dsv calculates total sold each row , add cube measure (probably easiest). add new calculated member cube using iif ,

hi guys, at moment want send email each supplier outstanding orders. have got loop setup correctly in ssis have issue script. here's script below. use db select * from (                 select d.email,                 o.identity,                 stuff((select ',' + stats + ' ' + parts                                 orderits                                 orderid = o.identity                                 , datediff(d, current_timestamp  , duedate) = 8                                 xml path(''), type).value('.', 'nvarchar(max)'), 1, 1, '')                                 items                 orders o                 inner join traders t                 on o.traderid = t.id                 inner join email d                 on t.id = d.traderid                 group o.identitfication, d.email ) x where x.items not null so @ moment getting seperate rows per order. when

visual studio 2010 tfs 2010 i have customized defect workitem type, used witadmin importwitd import xml , told work item type has completed. when tried create defect, none of changes seen? ideas?   -isaac isaac hello isaac, thanks post. to deal issue, please first make sure new created work item type imported team project. , osiris mentioned, should refresh team project collection , try again. if still can’t see work item type, please reconnect tfs. thanks, vicky song [msft] msdn community support | feedback us get or request code sample microsoft please remember mark replies answers if , unmark them if provide no help. Archived Forums V  >  Team Foundation Server - General

hey everyone, i have fuzzy lookup in integration services packages not seem run. pulling data table in sql server 2008 r2 , comparing results data another  table in sql server (same database & instance)  using fuzzy lookup match similarities between data sets. when data flow task reaches fuzzy lookup, dos box pops second , packages finishes message of "finished. cancelled". last message in execution results displays: "information: execute phase beginning". again, there no excel files being processed or utilized in package.   i've tried running packages both in 32 bit , 64 bit mode no luck. i've tried advice listed here  : i'm @ loss. not sure can short of reinstalling visual studio.  thoughts? migince info visual studio 2008 3.5 sp1 version number: 9.0.30729.4462 qfe then it's time remove , re-install developer tools apply pending sps. arthur my blog

hi guys               i facing error while exporting test cases tfs 2010 excel. can share thoughts on this. waseem bukhari cmer wsbukhari hi wsbukhari, thank post. what's version of office? far know, work item add-in ms excel , project in team explorer support office 2007 , later version, if not install right version office, please install 1 of them have try. if install office 2007 or later version, experience tf237002, please refer article to have try. regards, lily wu [msft] msdn community support | feedback us Archived Forums V  >  Team Foundation Server - Project Management & Work Item

hi, am using silverlight 4. want serialize class object xml file.that created in isolated storage. serialize , deserilize executed in 2 button clicks. requirement want serialize number of objects single xml file , dont repeate root tag, each time click button. how can it. using xmlserializer class that. works single button click. if click again exception in thrown , shows problems in root tag........... if delete file eachtime before write xml file. works fine.... plz me solve this...... thanks.......... senraj hi, i understand want append serialized object xml exist xml file, suggest take a at  linq xml . http://msdn.microsoft.com/en-us/library/bb387098.aspx thanks, Silverlight  >  Silverlight Controls and Silverlight Toolkit

does know if analysis services has binaries optimized amd opteron? reason ask seeing dramatic performance difference between 2 systems: system: dual xeon irwingdale 3.4 ghz, chipset e7525, 4gb ram os: windows xp pro sp2 fact rows: 20,000,000 aggregations: 1300 processing time: 3 hrs system: dual amd opteron 246 (2.0 ghz), amd chipset 8000 (mb tyan s2885). 4 gb ram os: windows 2003 enterprise (sp1) fact rows: 20,000,000 (same data set 1st case) aggregations: 1300 processing time: 6-7 hrs both test environments have the: same ram speed same model hdds is difference due lack of amd-specific optimizations in ssas binaries? or other reason? also there way reduce thread priority on ssas binary during optimization? seems hose machine (windows 2003 ent.) during processing. when attempted change processing priority through task manager got access denier error (logged in admin) did test under same os , 100% equial options? such difference have acounted seems screwy.

hi all, recently downloaded bids 2010 , created package. pakcage has data flow task , in t calls function. when point package use source sql server 2005 function performs , no issues, when point package toa  source sql server 2008 i'm getting error: an ole db record is available . source : "microsoft sql server native client 10.0" hresult : 0x80040e14 description : "statement(s) not prepared." . ole db record is available . source : "microsoft sql server native client 10.0" hresult : 0x80040e14 description : "cannot find either column " dbo " or user-defined function or aggreate " dbo . fn_get_date_time ", or name ambiguous." . but there no problem whatsoever when sourrce 2005 server. idea if there bug or there different way call function 2010 2008. please need planning upgrade packages 2010. thanks if you're not allowed post picture post picture file sharing service , give link. a

declare @partitiondate varchar(8), @date int select @partitiondate = max(partitiondate) partitionlog (nolock) select @date = min(datekey) dimdate cast(datekey varchar(8)) > @partitiondate if not convert(varchar(8),getdate(),112) = @partitiondate select @partitiondate = cast(datekey varchar(8)) dimdate (nolock) datekey = @date select @partitiondate partitiondate , 'iisdw_' + @partitiondate partitionname go i have above sql stmt in excute sql task , declared 2 variable "partitiondate" , "partitionname" in package, result set hav given "single row" , when run etl error as  [execute sql task] error: error occurred while assigning value variable "partitiondate": "exception hresult: 0xc0015005". does package variable datatype match datatype of parameter? is package variable assigned parameter in task editor? and parameter name in task editor match parameter names in stored procedure?

can moderator please delete post below url: http://social.msdn.microsoft.com/forums/en-us/sqlxml/thread/2bf61862-acfc-4a7d-8717-dfa88a356221 when posting question didnt realise posting copy of assignement.can pelase delete post.wbob replied question , gave answer question helped me lot answer shows fields names of assignment.iniitally when posted question included description of complete xml file field names in changed today single line answer posted wbob ,am not able edit that.i dont mind being there field names .......thanks lot wbob helping me.....thanks moderator deleting post. so got assignment , want answer deleted won't busted school/uni.  think should stay you've cheated! jeff wharton msysdev (c.sturt), mdbdsgnmgt (c.sturt), mct, mcpd, mcitp, mcdba blog: mr. wharty's ramblings mc id: microsoft transcript please mark solved if i've answered question, vote helpful other user's find solution quicker

i have installed team foundation build on windows 2003 standard edition inside virtual machine running on virtual sever 2005 r2. i have confirmed team build service running. when connecting client machine , build started following error occurs: tf42056: build service not connect team foundation server: object reference not set instance of object. i have enabled trace logger @ level 4 (the default), , connection request logged no error written. what causing , can more ideas? sorry english :) i mean, in build machine, have windows service called "build services", can check account service using run?? maybe account doesn't have permissions in tfs, it's idea, error generic. Archived Forums V  >  Team Foundation Server - Build and release management

i create report showing code has been checked-out longer 2 weeks. don't see type of information contained in bisdwdb, assume need access vsteamscc db instead. correct? if so, tables need select? i don't know whether can achieve using reports feature, can use status command information.  if run "h status $/ /r /user:* /format:detailed" you'll see every pending change in system , when each change pended (you need /format:detailed date). buck Archived Forums V  >  Team Foundation Server - General

i have been thru bol , book "data mining sql server 2005," still don't understand fact table creation. if understand correctly, data mining cannot done without fact tables. correct? also, how 1 go creating fact table. here's example of 1 thing which trying do:   i have several tables contain results of different types of analysis. tables use datetime primary key (yes, datetimes unique per table). in case, 1 table contains variable predict. contains integer data pertaining current state (e.g. 0 1 state, +1 another, -4 still another, etc.). other tables each contain 1 or more variables used try predict state of (hopefully) predictable variable described in first table. alternatively, understand in what, if any, ways are the other variables associated current state of predictable variable.   based on that, how physically create fact table? there fact table wizard? have created manually with joins in a query? can see, @ a loss understand how fact table created.

i have read post on printing report manager work "test" may appear printed "tes t". have issue on 1 of forms.. is there workaround resolving issue? print driver on desktop? have co-worker test see if prints them.. note: seem notice after "y" printed. any thoughts? thanks this sounds issue image rendering extension.  test theory, export report image file (like jpg) , let know if same thing happens.  checked connect site , didn't find bug reported behavior search criteria.  may want search @ http://connect.microsoft.com/sqlserver/searchresults.aspx if can produce in simple report, please post site , include copy of report (or suficient instructions reproduce behavior) what product version using?  patches & service packs date? paul turley, mvp, www.sqlserverbiblog.com *please vote if helpful* SQL Server  > 

good morning, oh esteemed ssis superiors! in thread, detailed need use transactionoption to make use of sequence containers. i learned that, in order use setting, must have msdtc enabled on local box , server. if service not running, error, " failed acquire connection 'connection'. connection may not configured correctly or may not have right permissions on connection ," occurs when have transactionoption set " required ." i able set msdtc on local box, management has decided not enable msdtc on server, blocking use of sequence containers. these seem useful tools, don't have experience package able advocate enabling msdtc sufficiently. seems ability roll events in failed sequence wasn't enough - though, seems pretty darn argument novice. so, question group is, other arguments might use gently nudge management turning on msdtc without being aware of being nudged? if need have transaction spans single database, there other ways accompl

hi, i've got javascript needs know when silverlight object loaded , running. have tried <param name="onpluginloaded" value="myfunction">, not work, @ least not in beta 2. instead, <param name="onload" value="myfunction"> seems work. however, requires myfunction function in global scope (window). writing code web page can contain several similar silverlight objects, created dynamically after page load. then, need event handler function in javascript class, , class instantiated in several objects. ideally speaking, event handler should not public function either. so, there way can pass function reference onload/onpluginloaded event in silverlight plugin? thanks answer. not have been looking for, have found decent solution myself. i assign javascript object property silverlight dom object in web page, , silverlight application, access object using htmlpage.plugin.getproperty method. example: javascr

hi all i have .bcp file containing lakhs of data. now want few records out of particular time frame 2-4 days, how can make query or store procedure same, know can done in command line, how filter data date? any b highly appreciated. http://hightechpost.blogspot.com / hello, please, modify post replace "lakhs" clearer word ( french , when using bing translator translate in french , obtain "vie" retranslated in english "life" ...) beforehand. i suppose when writing .bcp file , mean file created bcp utility. bcp has queryout argument permits select rows database, there no queryin argument. could provide edition , version of sql server ? ( if have @ least standard edition , may use ssis integrate data thru packages) i propose move thread towards http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/threads or http://social.msdn.microsoft.com/forums/en-us/sqltools/threads the move ( done moderators ) permits

we can create multiple snapshots database although increases i/o. if want restore snapshot, have delete of remaining snapshots except 1 restoring from. limitation coming , whats reasoning behind this? there technical limitation or way putting brakes on functionality not used/abused instead of traditional backups?   i coulnd't find documentation on this, if knew please educate me or provide me pointers. appreciate help.   thanks, sankar the snapshots not contain data of main db.  only when change in main db, original image of changed page copied existing snapshots. so when your read snapshot, , page containing data involved has not been changed since snapshot bulit, are fetching the page form main db in fact. all snapshots base on main db, so if wanna restore it,  all unnecessary dependency should removed first. SQL Server  > 

hi all, i have a   database on 150gb in size , estimated size of 1 terabyte. planning split database various filegroups. have separated indexes , data database. tempdb in separate physical drive. i thinking if it’s idea place each filegroup separate drive. drives not physical drives partitioned, drive portioned raid 1+0. would great performance benefit of placing filegroups on own drives ? placing filegroup structure below. no filegroup drive 1 primary f 2 log j 3 ad_data g 4 ad_indexes h 5 cv_data i 6 cv_indexes j 7 dim_data k 8 dim_indexes l 9 fact_data m 10 fact_indexes n 11 staging_data o 12 staging_indexes p 13 org_data q 14 org_indexes r 15 tmp_data s 16 tmp_indexes t any appreciated   thx it depends whether these drives have