aboutsql.blogspot.com
Vishal SQL Blog: SQL Server 2008 (catmai) new features
http://aboutsql.blogspot.com/2007/12/sql-server-2008-catmai-new-features.html
It's all about SQL and my understanding about SQL. Sunday, December 09, 2007. SQL Server 2008 (catmai) new features. Transparent Data Encryption (encryption while data is 'still' on disk, transparent to applications). External Key Management (Consolidation of key management, integration with external products). Data Auditing (1st-class 'AUDIT' objects; DDL support; audit objects, principals, data, etc. support for multiple logging targets). Integrate with Microsoft System Center. Extended Events (high pe...
aboutsql.blogspot.com
Vishal SQL Blog: ISOLATION LEVEL - SQL Server 2005
http://aboutsql.blogspot.com/2007/09/isolation-level-sql-server-2005.html
It's all about SQL and my understanding about SQL. Sunday, September 30, 2007. ISOLATION LEVEL - SQL Server 2005. SET TRANSACTION ISOLATION LEVEL. Specifies that statements can read rows that have been modified by other transactions but not yet committed. In SQL Server 2005, you can also minimize locking contention while protecting transactions from dirty reads of uncommitted data modifications using either:. The READ COMMITTED isolation level with the READ COMMITTED SNAPSHOT database option set to ON.
aboutsql.blogspot.com
Vishal SQL Blog: February 2007
http://aboutsql.blogspot.com/2007_02_01_archive.html
It's all about SQL and my understanding about SQL. Sunday, February 18, 2007. Optimizing SQL Server Performance - 1. Normalize Logical Database Design. Accelerates sorting and index creation, since tables are narrower. Allows more clustered indexes, since there are more tables. Indexes tend to be narrower and more compact. Allows better use of segments to control physical placement of tables. Fewer indexes per table, helping UPDATE performance. Subscribe to: Posts (Atom). Vishal has 10 years of experienc...
mssrs.blogspot.com
SQL Reporting Services: July 2005
http://mssrs.blogspot.com/2005_07_01_archive.html
Friday, July 29, 2005. Deploying Report Servers in a Cluster. Posted by Vishal Sharma @ 4:45 AM 3 comments. Posted by Vishal Sharma @ 4:43 AM 0 comments. Deploying a Report Server for Internet Access. Settings in the rswebapplication.config. File provide values that are used to direct requests from Report Manager to a report server. By default, the configuration file includes ReportServerUrl. To access a report server on the Internet, you must add a ReportServerExternalURL. Hyderabad, AP, India.
aboutsql.blogspot.com
Vishal SQL Blog: Locking - 2000
http://aboutsql.blogspot.com/2007/09/locking-2000.html
It's all about SQL and my understanding about SQL. Saturday, September 29, 2007. Another way to look at the difference between locks and latches is that locks ensure the logical consistency of the data and latches ensure the physical consistency. Latching happens when you place a row physically on a page or move data in other ways, such as compressing the space on a page. SQL Server must guarantee that this data movement can happen without interference. The Lock Manager and Isolation Levels. UPDATE publi...
aboutsql.blogspot.com
Vishal SQL Blog: July 2005
http://aboutsql.blogspot.com/2005_07_01_archive.html
It's all about SQL and my understanding about SQL. Friday, July 29, 2005. All about Locking in SQL 2000. Full article coming soon. Four aspects of locking. Granularity of the lock. Duration of the lock. Ownership of the lock. At the table, page, or row level. SQL Server also locks index keys and ranges of index keys. Depends on the mode of the lock and the transaction isolation level. Few useful system tables for locks. Few useful commands sp for locks. Thursday, July 28, 2005. Scaling out works best whe...
aboutsql.blogspot.com
Vishal SQL Blog: March 2011
http://aboutsql.blogspot.com/2011_03_01_archive.html
It's all about SQL and my understanding about SQL. Thursday, March 17, 2011. 50 New Features of SQL Server 2008. Enable encryption of an entire database, data files, or log files, without the need for application changes. Benefits of this include: Search encrypted data using both range and fuzzy searches, search secure data from unauthorized users, and data encryption without any required changes in existing applications. Automatic Recovery of Data Pages. Database mirroring requires data transmissions be...
aboutsql.blogspot.com
Vishal SQL Blog: SQL Server Architecture - 2000
http://aboutsql.blogspot.com/2007/09/sql-server-architecture-2000.html
It's all about SQL and my understanding about SQL. Saturday, September 29, 2007. SQL Server Architecture - 2000. Subscribe to: Post Comments (Atom). AdClickMedia Text Ads Code START -. ISOLATION LEVEL - SQL Server 2005. SQL Server Architecture - 2000. Temp Table Performance Tuning Tips. Resolving SQL Server Hardware Bottlenecks. Performance Tuning SQL Servers Configuration Sett. SQL Server Join Hints. Useful SQL Server DBCC Commands. SQL Server 2000 Clustering Tips. SQL Server Query Hints.
aboutsql.blogspot.com
Vishal SQL Blog: Indexes
http://aboutsql.blogspot.com/2007/09/indexes.html
It's all about SQL and my understanding about SQL. Saturday, September 29, 2007. An index provides fast access to data when the data can be searched by the value that is the index key.Indexes allow data to be organized in a way that allows optimum performance when you access or modify it. In a nonclustered index, the lowest level of the tree (the leaf level) contains a bookmark that tells SQL Server where to find the data row corresponding to the key in the index. If the table has a clustered index, the ...
aboutsql.blogspot.com
Vishal SQL Blog: December 2007
http://aboutsql.blogspot.com/2007_12_01_archive.html
It's all about SQL and my understanding about SQL. Sunday, December 09, 2007. SQL Server 2008 (catmai) new features. Transparent Data Encryption (encryption while data is 'still' on disk, transparent to applications). External Key Management (Consolidation of key management, integration with external products). Data Auditing (1st-class 'AUDIT' objects; DDL support; audit objects, principals, data, etc. support for multiple logging targets). Integrate with Microsoft System Center. Extended Events (high pe...