Feeds:
Posts
Comments

Archive for the ‘Best Practices’ Category

SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning

Posted in Best Practices, Database, MVP, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged , on October 20, 2009 | 4 Comments »

PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is the most awaited conference of SQL Server in world. Everybody will be there and there will be something for everybody. My core expertise is in Query Optimization [...]

Read Full Post »

SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Index, SQL Joins, SQL Optimization, SQL Performance, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on October 6, 2009 | 8 Comments »

SQL Server never stops to amaze me. As regular readers of this blog already know that besides conducting corporate training, I work on large-scale projects on query optimizations and server tuning projects. In one of the recent projects, I have noticed that a Junior Database Developer used the query hint Force Order; when I asked [...]

Read Full Post »

SQL SERVER – Download Script of Change Data Capture (CDC)

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Download, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 1, 2009 | 4 Comments »

My article written on subject of Introduction to Change Data Capture (CDC) in SQL Server 2008 is quite a popular and I have received many request for uploading the script associated with this subject.
Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, [...]

Read Full Post »

SQL SERVER – Best Practices – Implementation of Database Object Schemas

Posted in Best Practices, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on August 28, 2009 | Leave a Comment »

Microsoft SQL Server 2005 introduced the concept of database object schemas. Schemas are analogous to separate namespaces or containers used to store database objects. Security permissions apply to schemas, making them an important tool for separating and protecting database objects based on access rights. Schemas reduce the work required, and improve the flexibility, for security-related [...]

Read Full Post »

SQLAuthority News – USB Drive Fails to Copy Large File

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on August 14, 2009 | 8 Comments »

I am currently traveling on a month-long training assignment for Business Intelligence. For demonstration purposes, I use Virtual PC files and hands-on lab examples for attendees of the training. The size of my VPC file is about 15 GB. Initially, I copy this file to a USB Drive and then move it to other computers, [...]

Read Full Post »

SQL SERVER – Backup master Database Interval – master Database Best Practices

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 12, 2009 | 14 Comments »

During a recent consultancy project, I was asked to review a Database Backup plan. While going through the plan, I noticed that there was no backup for the master database. When I questioned this, the DBA informed me that it was not necessary. I was startled and couldn’t resist explaining to him that the master [...]

Read Full Post »

SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

Posted in Best Practices, DBA, Database, Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on July 29, 2009 | 32 Comments »

Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE. Today, we will go [...]

Read Full Post »

SQL SERVER – Clustered Index on Separate Drive From Table Location

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on June 18, 2009 | 7 Comments »

How to improve performance of SQL Server Queries is a common topic of discussion among many of us. Much has been said, much has been discussed. Few days back, I had an interesting discussion with one of the Junior developers regarding performance improvement of SQL Server Queries. We discussed on how by using a separate [...]

Read Full Post »

SQL SERVER – Questions and Answers with Database Administrators

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 11, 2009 | 8 Comments »

I have been in India for long time now, and at present, I am managing a very large outsourcing project. Recently, we conducted few interviews since the project required more Database Administrators and Senior Developers, and I must say it was an enthralling experience for me! I got the opportunity to meet some very talented [...]

Read Full Post »

SQL SERVER – 10 Reasons for Database Outsourcing

Posted in Best Practices, DBA, Database, Readers Contribution, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on May 10, 2009 | 6 Comments »

10 Reasons for Database Outsourcing
While you may feel that your IT material is safe and handled effectively within your own company, these reasons may give you some perspective on why you may want to consider other options.
Cost Reduction – Perhaps the most popular reason to outsource your database is the overall reduction in cost that [...]

Read Full Post »

Older Posts »