SQL Server Database Coding Conventions,SQL Server Support,Optimize database snapshots

Tutorials
ASP.Net & C#

ASP

Perl and PHP

Java Scripts

C and C++

Ajax Tutorials

J2ee, J2Me, Java

Python & Ruby Rail

Crystal Report

Sap

CGI

XML

Cold Fusion & CFML

HTML, DHTML & CSS

Dreamweaver

FLASH

Photoshop/Web Designing

Tools & Utilities

Oracle/D2K

Sql Server

MySql

Domain Name Registration

Remotely Hosting
Web/Server Application

Hotel Marketing

Internet and Law

	Search Engine Optimization/SEO

	E-Commerce

	Interview Questions

Previous < 3 4 5 6 7 8 9 10 11 12 > Next

SQL Server

SQL Server Database Coding Conventions

Here are some programming guidelines and best practices, keeping quality, performance and maintainability in mind. This list many not be complete at this moment, and will be constantly updated. BTW, special thanks to Tibor Karaszi (SQL Server MVP) and Linda (lindawie) for taking time to read this article and providing suggestions.

SQL Server Support

The objective of the Microsoft SQL (MSSQL) port is to provide another database alternative to MYSQL to take advantage of SQL server in business environments where Mysql may be a barrier to entry. The goal was to provide the ability for GL1.4.0 to work in either Mysql or MS SQL server with zero code changes required to be done by the end user. The version(s) of SQL supported are SQL 2000 and above, including the MSDE.

Optimize database snapshots

Tempdb in SQL Server 2005 provides improved performance. In this tip, get insight to these tempdb changes and write advanced SQL Server code. More powerful MDX in SQL Server 2005 Analysis Services includes query support and expression/calculation language to help support business intelligence needs. See how it works. In this tip, you'll see how to minimize the size of I/O bottlenecks in your primary database, while understanding the role of sparse files in using the database snapshot. Secure database systems require sharp skills on behalf of a SQL Server DBA. This tip outlines five steps to build your security expertise and limit system vulnerabilities.

What's New in SQL Server 2005 SP2

In Microsoft SQL Server 2005 Service Pack 2 (SP2), the following components have new or improved features.The 2007 version of Microsoft Office requires the installation of SQL Server 2005 Analysis Services SP2 to support all its business intelligence features. If you run against an instance of Analysis Services that does not have SP2 installed, features of Microsoft Office that require SP2 will be disabled.

Performance and scalability has been improved with regard to subselects, running sum calculations, NUMA optimizations for partition processing, partition query scalability, ragged hierarchies, visual totals, ROLAP dimensions, cell writeback, many-to-many dimensions, drillthrough, semi-additive measures, unary operators, and stored procedures.

Hacking an SQL Server

Microsoft SQL Server is a popular and robust environment for many applications that use databases – it features excellent multi-access capabilities, comprehensive security coverage and can easily be transported to other database platforms. Unfortunately, such potential will not be realized – notwithstanding the use of royalty-free MSDE (Microsoft Database Engine optimized for individual or small workgroup solutions) if adequate security protection to the databases is not provided as a minimum.

Previous < 3 4 5 6 7 8 9 10 11 12 > Next