SQL Server Blogs - http://www.sqlcommunity.com

Friday, November 21, 2008

Microsoft SQL Server Community

SQL Home

Events

Articles

Resources

Community

Job Board

You Are Here: »

SQL Bloggers

SQL Community Portal

SQL Community Home
SQL Tips & Tricks

SQL Blogs
SQL Discussion Forums
SQL Automation Central
SQL Community Articles

SQL TechNet Articles

SQL Upgrade Central

SQL Laboratory

SQL Wikipedia

SQL Server RADIO

SQL World Wide Events

SQL Job Listings

SQL Clinics

Recently Submitted Articles

SQL Server 2008 Data Compression

How to Retrieve the Last Objects Changed In SQL Server 2005

Multi-Server Deployment and Management Using SQL Server Central Management Server

Compound Assignment operators and Direct Assignment support in SQL Server 2008

BEST PRACTICES FOR WRITING BETTER SQL

Recent SQL Clinic Articles

Configuring DBM on a Low-Bandwidth Networks

Achieving Geo-redundancy with Database Mirroring

Best Practices when performing maintenance in a DBM environment

How to read data from a Mirror database using Database Snapshots

Comparing Failover Clustering with Database Mirroring

Recent SQL Server Blog Posts

Author:	Sirisha Kommushetty	Created:	4/28/2008 6:17 PM
My blog has informational reads/picks of various genres starting from minute inspirational/motivational reads to technical TitBits related to my play with T-SQL[SQL Server]/CLR Stored Procedures, LINQ With SQL, VSTS DBPro, and BDC feature of MOSS 2007.

Row Constructors in SQL Server 2008

By Sirisha Kommushetty on 5/12/2008 12:11 AM

Row Constructors are a relief to single ton manual inserts. They definitely help boost the efficiency of I-Transactions (INSERT).

If you really want to second my statement

… then I bet you should have a quick look at the case study below.

Dependency Tracking in SQL Server 2008

By Sirisha Kommushetty on 5/3/2008 7:54 PM

Dependency Tracking in SQL Server 2008 is an aspect that helps users (SQL Developer/DBA) to track all the underlying dependencies or references of a given DB Object with minimum effort.

SQL Server 2008 facilitates some really cool utilities that are used to:

§ Track both schema-bound and non-schema-bound dependencies.

§ Trac Read More »

SQL Server 2000 Downloads

SQL Server 2000 Service Pack 4 (SP4)

SQL Server 2000 Service Pack 3a (SP3a)

SQL Server 2000 Service Pack 2 (SP2)

SQL Server 2000 Service Pack 1 (SP1)

SQL Server 2000 Reporting Services Downloads

Reporting Services Service Pack 2 (SP2)

Reporting Services Service Pack 1 (SP1)

SQL Server 2000 Notification Services SP Downloads

Notification Services 2.0 Service Pack 1 (SP1)

SQL Server 2000 Notification Services, Enterprise Edition 2.0 Service Pack 1 (SP1)

SQL Server 2000 Notification Services, Standard Edition 2.0 Service Pack 1 (SP1)

SQL Server CE Downloads

SQL Server CE Service Pack 1 (SP3)

SQL Server CE 1.1 Service Pack 1 (SP1) Update

SQLXML 3.0 Service Pack Downloads

SQLXML 3.0 Service Pack 3 (SP3)

SQLXML 3.0 Service Pack 2 (SP2)

SQLXML 3.0 Service Pack 1 (SP1)

SQL Server 2000 JDBC Driver

SQL Server 2000 Driver for JDBC Service Pack 3 (SP3)

SQL Server 2000 Driver for JDBC Service Pack 2 (SP2)

SQL Server 2000 Driver for JDBC Service Pack 1 (SP1)

MDAC 2.6 Download

Microsoft Data Access Components (MDAC) 2.6 Service Pack 2 (SP2)

SQL Server 2000 Tools Downloads

Microsoft SQL Server 2005 Upgrade Advisor

Support Tools Available for Stress Testing and Performance Analysis

PSSDIAG Data Collection Utility

Download SQL Server Accelerator for Business Intelligence (BI)

SQL Server 2000 Security Tools

Microsoft SQL Web Data Administrator

SQL Server 2000 Desktop Engine Deployment Toolkit (Sample Application)

SQL Server Management Pack

SQL Server 2000 Best Practices Analyzer 1.0

SQL Server 2000 Driver for JDBC Service Pack 3 (SP3)

MSDEToText Tool for Internet Security and Acceleration (ISA) Server 2004

SQL Server 2000 SP4 Replication Components

SQL Server 2000 Web Services Toolkit

Updated Samples for SQL Server 2000

SQL Server 2000 Report Pack for IIS Logs

SQL Server 2000 Report Pack for Microsoft SharePoint Portal Server

SQL Server 2000 Report Pack for Microsoft Exchange

SQL Server 2000 Report Pack for Financial Reporting

SQL Server 2000 Report Pack for Great Plains

SQL Server Report Pack for Microsoft Customer Relationship Management (CRM)

SQL Server 2000 Report Pack for Microsoft Axapta 3.0

SQL Server 2000 Report Pack for Microsoft Axapta 3.0

SQL Server 2000 Report Pack for Microsoft SharePoint Portal Server 2003

SQL Server 2000 Report Pack for Internet Information Services (IIS) Logs

SQL Server 2000 Report Pack for Microsoft Business Solutions—Great Plains 8.0

SQL Server 2000 Report Pack for Microsoft Customer Relationship Management (CRM)

SQL Server 2000 Report Pack for Microsoft Exchange

SQL Server 2000 Report Pack for Financial Reporting

Reporting Services for SQL Server 2000 Trial Software

Reporting Services for SQL Server 2000 Books Online Update

Developing Applications Using SQL Server 2000 Reporting Services

SQL Server 2000 Health and History Tool (SQLH2) Reports

SQL Server CE 2.0

SQL Server CE 2.0 Books Online

SQL Server CE 2.0 Update for Use with IIS and SQL Server 2000 SP4

Important Information for SQL Server 2000 SP3 and SP3a Users

Notification Services Events

SQL Server 7.0 and 6.x Downloads

SQL Server 7.0 Books Online

SQL Server 7.0 Service Pack 4 (SP4)

SQL Server 7.0 Security Update for Service Pack 4

SQL Server 7.0 Service Pack 3 for Intel Platforms

SQL Server 7.0 OLAP Services SP3

SQL Server 7.0 Service Pack 2 (Intel)

SQL Server 7.0 Service Pack 1 for Intel

SQL Server 7.0 Security Patch MS03-031

Fix: Service Pack Installation May Save Standard Security Password in File

SQL Server 6.5 Service Pack 5a (SP5a)

SQL Server 7.0 Tools Downloads

Migrating Sybase Applications to SQL Server 7.0

SQL Server Management Pack

SQL Server DataSizer Tool

OLAP Manager Add-In Kit

Office 2001 Data Access Update

SQL Server 7.0 Samples

OLAP Services: Web Browser Sample

Active Server Pages Sample Application

Active Server Pages Sample Application

Visual Basic Sample Application

Visual C++ Sample Application

OLAP Services Sample

SQL Server 2005 & SQL Server 2000 Best Practices

· Database Snapshot Performance Considerations under I/O-Intensive Workloads

· Best Practices for Migrating Non-Unicode Data Types to Unicode

· Database Mirroring and Log Shipping Working Together

· Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

· The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode

· Precision Considerations for Analysis Services Users

· Scale-Out Querying with Analysis Services Using SAN Snapshots

· Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

· XML Best Practices for Microsoft SQL Server 2005

· Performance Optimizations for the XML Data Type in SQL Server 2005

· SQL Server 2005 Security Best Practices - Operational and Administrative Tasks

· SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

· Scale-Out Querying with Analysis Services

· SQL Server 2005 Analysis Services Processing Best Practices

· Pre-deployment I/O Best Practices

· Partial Database Availability

· Comparing Tables Organized with Clustered Indexes versus Heaps

· SQL Server 2005 Deployment Guidance for Web Hosting Environments

· Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios

· Implementing Application Failover with Database Mirroring

· OLAP Design Best Practices for Analysis Services 2005

· DBCC SHOWCONTIG Improvements and Comparison between SQL Server 2000 and SQL Server 2005

· TEMPDB Capacity Planning and Concurrency Considerations for Index Create and Rebuild

· Loading Bulk Data into a Partitioned Table

· Database Mirroring Best Practices and Performance Considerations

· SQL Server 2005 Performance Tuning using Waits and Queues

· Analysis Services 2005 Performance Guide

· SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Performance, and Scalability

· Microsoft SQL Server 2005 Tuning Tips for PeopleSoft 8.x

· Troubleshooting Performance Problems in SQL Server 2005

· SQL Server 2005 Best Practices Analyzer

· DMV Stats

Scripts and Tools for Performance Tuning and Troubleshooting SQL Server 2005

· Buffer Cache

· CPU and Optimization

· Indexes and Indexing

· Input/Output

· Query Plan Re-Use

· Retrieving SQL Text and XML Plans

· SQLOS: Schedulers, Runnable Queue, Waiter List

· Tempdb

· Transactions and Locking

· Wait Statistics

SQL Server 2000 Best Practices

· SQL Server 2000 SP3 Security Features and Best Practices: Security Best Practices Checklist

· Microsoft SQL Server 2000 Index Defragmentation Best Practices

· Best Practices Analyzer Tool for Microsoft SQL Server 2000

Email:
Name:
Message:
Send Copy?
Cancel Send

SQL Blog Archive

Archive

November 2008

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Monthly

Community Sharing Central

Submit SQL Articles

Submit SQL Scripts

Submit SQL Tips

Submit SQL Resources

Submit SQL Events

Submit SQL Bug

Submit Your Resume

Submit Your SQL Wish

Submit Job Posting

Submit Your FEEDBACK

Recently Submitted SQL Tips

Findind Occurrences of Text in the Database

Finding An Occurrence of a Column

List Indexes for all Tables in a Database

UPDATE Based Off of A Table

Configuring Virtual Memory for SQL Server System

Recently Submitted Scripts

ListallTableIndexes

Indentify Table(s) with Unique Constraint

Identify Table(s) without Index

Identify table(s) without Clustered Index in DB