SQL Tips and Tricks Archives - Page 419 of 536 - SQL Authority with Pinal Dave

SQL SERVER – 2008 – Management Studio New Features

April 5, 2009

Best Practices, SQL Scripts, SQL Server Management Studio, SQL Utility

Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008. This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested…

SQL SERVER – Mirrored Backup and Restore and Split File Backup

April 5, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Scripts

Introduction This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore. Conventional Backup and Restore Spilt File Backup and Restore Mirror…

SQL SERVER – Automated Index Defragmentation Script

April 4, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Index, SQL Scripts

Index Defragmentation is one of the key processes to significantly improve performance of any database. Index fragments occur when any transaction takes place in database table. Fragmentation typically happens owing to insert, update and delete transactions. Having said that, fragmented data can produce unnecessary reads thereby reducing performance of heavy…

SQLAuthority News – Launch of Gandhinagar SQL Server User Group

April 3, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DigiCorp, MVP, SQL User Group, SQLAuthority Author Visit

Gandhinagar SQL Server User Group launch event was held on March 27, 2009. This successful, well-attended event received very positive and warm community response. This launch event, unexpectedly, saw over 50 database enthusiasts participating. It was really a moment of pleasant surprise when we ran out of chairs. The otherwise…

SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP

April 2, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Backup and Restore, SQL Data Storage, SQL Utility

It goes without saying that Database Backup is the most important task for any Database Administrator (DBA). Naturally, large organizations always have a team of DBAs who execute Database Backup tasks. No matter how big or small an organization is, the importance of database backup remains the same across the…

SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column

April 1, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity, SQL Index, SQL Scripts, SQL Server DBCC, SQL System Table

Some time ago I was helping one of my Junior Developers who presented me with an interesting situation. He had a table with Identity Column. Because of some reasons he was compelled to delete few rows from the table. On inserting new rows in the table he noticed that the…

SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense

March 31, 2009

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Server, SQL Server Management Studio, SQL Utility, SSMS

While I was working with SQL Server 2008 IntelliSense, I realized that it was not functioning as I expected. Even after I had enabled IntelliSense it was still not opening any suggestions at all. After a while, I figured out some vital information regarding how to make sure IntelliSense smoothly works all the time without you giving any trouble. Let us learn how we can Enable IntelliSense.