:::: MENU ::::

Posts Categorized / Publications of Atif Shehzad on MSSQLTips.com

  • Apr 11 / 2012
  • 0
DBA best practices, dbDigger, Performance Tunning and Optimization, Publications of Atif Shehzad on MSSQLTips.com, SQL Server Filegroups

Configuring the default filegroup for a database with multiple filegroups

By default a single file group exists for SQL Server databases.  It is primary and default file group for that database. However for better manageability and performance optimization we may be required to configure additional file groups for particular database. Data may be spread over multiple files in different file groups. SQL Server provides an option to change the default file group from primary file group to any other. Read here my article related to Using Multiple File groups for a Database and Changing the Default File group.

  • Sep 06 / 2011
  • 0
Further utilizing the computed columns in your database design
Data Modeling and Database Design, dbDigger, Publications of Atif Shehzad on MSSQLTips.com

Further utilizing the computed columns in your database design

Computed columns are handy feature of SQL Server database design. Few months back i write an article related to basics of computed columns in SQL Server. Some readers furthers discussed about more flexibility in different scenarios. So click here to read my new article related to using computed columns with little enhancements for different requirements.

  • Apr 23 / 2011
  • 0
Constraints and Keys, Data Modeling and Database Design, dbDigger, Publications of Atif Shehzad on MSSQLTips.com

Understanding the update and delete rules for SQL Server Foreign Key Relationships

Foreign Key relationships are widely used in SQL Server database design. They provide numerous benefits. However there are some associated issues while applying update/delete statements on parent table .i.e. table with referenced primary key. SQL Server provides rules to manage the effect of operation on child records. It is important to know the use and effects of these rules. Read my recently published article  about Understanding the update and delete rules for SQL Server Foreign Key Relationships.

  • Mar 24 / 2011
  • 1
dbDigger, Disaster Recovery, Enhancement in new versions, Publications of Atif Shehzad on MSSQLTips.com

Emergency State for recovery of Corrupt SQL Server Database

A database in suspect state restricts access to data or settings. Data in suspect databases can not be pulled out nor you can perform recovery operations. In such cases, no matter the problem is due to any corrupt data page or log file, recovery is a night mare. SQL Server 2005 has introduced a very useful state for working with suspect databases. You can set the suspect database to emergency state and then exploit the wide range of operations on data and settings.

Click here to read full article with practical examples about using the Emergency State for a Corrupt SQL Server Database.
  • Dec 06 / 2010
  • 0
dbDigger, Publications of Atif Shehzad on MSSQLTips.com, SSMS tips and tricks

Scripting every task performed through SSMS GUI

Recently i explored a wonderful option provided in SQL Server Management Studio. SSMS allows to generate script for any operation performed through its GUI. It is awesome and provides you a comprehensive and authentic T-SQL code reference. You may save the GUI tasks performed in form of .sql files. Such code may be reused in daily tasks or scheduled jobs.

Click here to read my article for details of using this feature of SSMS.

Pages:1234567
Consult us to explore the Databases. Contact us