Wednesday, June 13, 2007
while OFF Table locks are applied for the duration of the index operation. Clustered index operations acquires a schema lock, which prevents all user access to the underlying table for the duration of the index operation. Nonclustered operations acquire a shared lock on the table that allows for read operations but prevents data modification.
While ON Table locks are not held for the duration of the index operation. SQL Server will first acquire an intent share lock, which allows queries and data modifications. Then SQL Server acquires a shared lock at the start of the index operation and quickly releases it. If a nonclustered index is being created, SQL Server will acquire a shared lock again at the end of the operation. If a clustered index is being created or dropped, or a nonclustered index is being rebuilt, SQL Server acquires a schema modification lock at the end of the operation. ONLINE can’t be set to ON for indexes created on local temporary tables (tables whose names start with the # character).
Monday, June 11, 2007
Silverlight is also trying to eliminate various Flash deficiencies by offering much higher quality video. Microsoft says that Silverlight supports up to 720p video--1280 x 720 resolution much higher then Flash. And unlike Flash, Silverlight won't require any expensive back-end servers for companies wishing to rollout the technology also Silverlight supports all major Web browsers, including Internet Explorer, Firefox, and even Apple Safari, which runs only on the Mac.
Currently not enough documentation is present on SilverLight but there are some white papers present on Microsoft site discussing architecture and overview of SilverLight. Also there are number of videos present on Microsoft site featuring silver light implementation by different clients for different solutions.
Following are some useful links;
Silverlight Architecture: http://msdn2.microsoft.com/en-us/library/bb428859.aspx
Silverlight Site: http://silverlight.net/
Silverlight Demo: http://ds.pilot.serving-sys.com/BurstingRes/WPFE/msn_tech.html
BBC Radio Demo: http://download.microsoft.com/download/f/7/2/f72cff89-5769-4bd1-ab7d-f4333adbef16/BBC_mix.wmv
"With Google Gears, we're tackling a key limitation of the browser in order to make it a stronger platform for deploying all types of applications and enabling a better user experience in the cloud," said Eric Schmidt, CEO of Google, in a statement. "We believe strongly in the power of the community to stretch this new technology to the limits of what's possible and ultimately emerge with an open standard that benefits everyone."
Google hopes Gears will become the standard for adding offline capabilities such as data storage, application caching, and multithreading to online applications.
David Mitchell Smith, Gartner web analyst, said that "The idea of taking Web applications offline is big," he said. While Google Gears can be viewed as a competitive move against Microsoft, he said that's not the only valid frame of reference.
Google Gears is also a threat for rich Internet applications. "Rich clients become less compelling the more the Web applications continue to grow," said Smith from Google. "Ajax has certainly taken a bite out of the opportunities that RIA developers thought they had."
Following are three Key features of Google Gear;
- A database, to store and access data from within the browser.
- A worker thread pool, to make web applications more responsive by performing expensive operations in the background
Google Gear is currently compatible with following set of browsers;
- Apple Mac OS X (10.2 or higher) o Firefox 1.5 or higher
- Linux o Firefox 1.5 or higher
- Microsoft Windows (XP or higher) o Firefox 1.5 or higher o Internet Explorer 6 or higher
Following are some useful links related to Google Gear
Google Gear: http://gears.google.com/
Sample Tutorial: http://code.google.com/apis/gears/tutorial.html
Sample Applications: http://code.google.com/apis/gears/sample.html
Sunday, June 10, 2007
You can download WSS 3.0 Application templates for creating scenario sepecific sites and solutions.
Some of these templates have to be deployed on Site level and some at server level targeting different scenarios.
Following are thier lists;
Site Admin Templates Board of Directors Business Performance Reporting Case Management for Government Agencies Classroom Management Clinical Trial Initiation and Management Competitive Analysis Site Discussion Database Disputed Invoice Management Employee Activities Site Employee Self-Service Benefits Employee Training Scheduling and Materials Equity Research Integrated Marketing Campaign Tracking Manufacturing Process Management New Store Opening Product and Marketing Requirements Planning Request for Proposal Sports League Team Work Site Timecard Management
Server Admin Templates Absence Request and Vacation Schedule Management Budgeting and Tracking Multiple Projects Bug Database Call Center Change Request Management Compliance Process Support Site Contacts Management Document Library and Review Event Planning Expense Reimbursement and Approval Help Desk Inventory Tracking IT Team Workspace Job Requisition and Interview Management Knowledge Base Lending Library Physical Asset Tracking and Management Project Tracking Workspace Room and Equipment Reservations Sales Lead Pipeline
There are currently 40 templates available. Following is the reference site; http://www.microsoft.com/technet/windowsserver/sharepoint/wssapps/templates/default.mspx