3. difference folder.item.update() and folder.item.systemupdate() is that Update will change modified / modified by information and if versioning is enabled it will increase the version number. SystemUpdate does not update these.
Developing a Sharepoint application would have all the fun of a video game, if only you had infinite lives. Dangers lurk hidden out there which, if you run into them, can be a blow to your project and waste a great deal of time. Damon gives just one example of a poisoned dagger in the game of Sharepoint Development: The Item Event Receiver.
Damon Armstrong (www.simple-talk.com/)
Karine Bosch (karinebosch.wordpress.com)
In today’s Hadoop world , MapReduce can be seen as a complement to an RDBMS. MapReduce is a good fit for processes that need to analyse the whole dataset, in a batch operation, specially for ad-hoc analysis. An RDBMS is good for point queries or updates, where the dataset has been indexed to deliver low latency retrieval and update times of a relatively small amount of data. MapReduce suits applications where the data is written once , and read many times, whereas a relational database is good datasets that are continually updated.
Thanks to Anindita Basak
1. (localdb)\V11.0 as the server name
2. Note that the instance name V11.0 is case sensitive
My Thanks to Aaron Bertrand(mssqltips.com) for the below
You can interact with SqlLocalDb using the command line. The following will tell you the version of SqlLocalDb:
C:\> SqlLocalDb info
If you want to create an instance:
C:\> SqlLocalDb create "MyInstance"
LocalDB instance "MyInstance" created with version 11.0.
To Start the instance:
C:\> SqlLocalDb start "MyInstance"
LocalDB instance "MyInstance" started.
You can also create an instance and start it in one command using the -s argument:
C:\> SqlLocalDb create "MyInstance" -s
To stop and delete an instance, you can issue two commands:
C:\> SqlLocalDb stop "MyInstance" C:\> SqlLocalDb delete "MyInstance"
If you try to just delete the instance without first stopping it, you will get this error:
Delete of LocalDB instance "MyInstance" failed because of the following error: Requested operation on LocalDB instance cannot be performed because specified instance is currently in use. Stop the instance and try again.
To check on the status and other details about an instance, you can run:
C:\> SqlLocalDb info "MyInstance"
Name: MyInstance Version: 11.0.2100.60 Shared name: Owner: METEORA\AaronBertrand Auto-create: No State: Running Last start time: 4/29/2012 6:17:24 PM Instance pipe name: np:\\.\pipe\LOCALDB#ABB78D50\tsql\query