All Articles - SQL Authority with Pinal Dave

SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting

July 17, 2008

MVP, SQL User Group, SQLAuthority Author Visit

I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking session about “SQL Server Best Practices“. I invite all of the SQL enthusiastic to stop by User Group Meeting and meet all the fellow developers, DBAs and members. Location : 401, TIME SQUARE,…

SQL SERVER – Readers Contribution to Site – Simple Example of Cursor

July 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with your knowledge. I recently come across very good communication between two of blog readers. I want to thank…

SQL SERVER – Deferred Name Resolution

July 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP…

SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2

July 14, 2008

Pinal Dave

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

SPARSE Columns, SQL Data Storage

Previously I wrote about SQL SERVER – 2008 – Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article. All SPARSE columns are stored as one XML column in database. Let us see…

SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings

July 13, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

It is very good to know our server and its feature which are available for configurations. SQL Server always has many features which can be enabled or disabled. One should at least know what are the options SQL Server provides. This blog post we will learn how to display or change global configuration settings.

SQL SERVER – 2008 – User Account – sa or sysadmin

July 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Security

Just a day ago, I noticed ‘sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ‘sa’ account. ‘sysadmin’ is actually replacement for legacy ‘sa’ account. ‘sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It is recommended to all the users who switch to SQL Server 2008 to start migrating to ‘sysadmin’ from ‘sa’.

SQL SERVER – 2005 – Two Important Security Update

July 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security

If you are using SQL Server 2005, following two are very important security updates not to be missed. Security Update for SQL Server 2005 Service Pack 2 (KB948108) A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your…

SQL SERVER – 2008 – Introduction to SPARSE Columns

July 10, 2008

Pinal Dave

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

SPARSE Columns, SQL Data Storage, SQL Scripts

I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason…

SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations

July 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Utility

Sometimes things just go very convenient and we wish that how come it was not available in earlier versions. Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small…

SQL SERVER – Find Space Used For Any Particular Table

July 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Data Storage, SQL Scripts, SQL Server, SQL Stored Procedure

We often run out of the space in our drive and that is the number 1 cause of SQL Server engine stop running on various machines. Quite often we wonder how much space if any of the objects takes in the database. It is very simple to find out the space used by any table in the database.