2009 - Page 21 of 55 - SQL Authority with Pinal Dave

SQLAuthority News – USB Drive Fails to Copy Large File

August 14, 2009

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

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…

SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service

August 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Server Agent, SQL Server Security

Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why the SQL Server Agent starts before SQL Server Engine does? He made the very valid point that as the SQL Server Engine is the core…

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

August 12, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, SQL Backup and Restore

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…

SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario

August 11, 2009

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Database, DBA, SQL Constraint and Keys, SQL Index

About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided…

SQLAuthority News – A Quick Guide to Twitter

August 10, 2009

Pinal Dave

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

I am a very big fan of Twitter. I have been using it for quite sometime now and I think it is a very convenient way to stay connected with friends, families, and even the world. You can share or connect with them in real-time and tell them what you…

SQLAuthority News – Interview with SQL Server MVP Glenn Berry

August 9, 2009

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, MVP

Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS. He is also an Adjunct Faculty member at University College – University of Denver, where…

SQL Server – Multiple CTE in One SELECT Statement Query

August 8, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTE, SQL Joins, SQL Scripts

I have previously written many articles on CTE. One question I get often is how to use multiple CTE in one query or multiple CTE in SELECT statement. Let us see quickly two examples for the same. I had done my best to take simplest examples in this subject. Option…