All Articles - SQL Authority with Pinal Dave

SQL SERVER- Differences Between Left Join and Left Outer Join

January 22, 2011

There are a few questions that I had decided not to discuss on this blog because I think they are very simple and many of us know it. Many times, I even receive not-so positive notes from several readers when I am writing something simple. However, assuming that we know…

SQLAuthority News – 1600 Blog Post Articles – A Milestone

January 21, 2011

Pinal Dave

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

It was really a very interesting moment for me when I was writing my 1600th milestone blog post. Now it`s a lot more exciting because this time it`s my 1600th blog post. Every time I write a milestone blog post such as this, I have the same excitement as when…

SQLAuthority News – Scaling Up Your Data Warehouse with SQL Server 2008 R2

January 20, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Data Warehouses are suppose to be containing huge amount of the data from the beginning. However, there are cases when too big is not enough. Every Data Warehouse Admin will agree that they have faced situation where they will need to scale up their data warehouse. Microsoft has released white…

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance

January 19, 2011

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

Earlier, I had written two articles related to Shrinking Database. I wrote about why Shrinking Database is not good.

SQL SERVER – 4 Tips for ETL Software IDE Developers

January 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, ETL

In a previous blog, I introduced the notion of Semantic Types. To an end-user, a seamlessly integrated semantic typing engine significantly increases the ease of use of an ETL IDE (integrated development environment, or developer studio). This led me to think about other ease-of-use issues I have encountered while building ETL…

SQL SERVER – A Funny Cartoon on Index

January 17, 2011

Pinal Dave

SQLAuthority News

SQL Cartoon, SQL Humor, SQL Index

Performance Tuning has been my favorite subject and I have done it for many years now. Today I will list one of the most common conversations about Index I have heard in my life. Let us see a funny cartoon on the Index and Performance Tuning.

SQLAuthority News – Whitepaper Download – Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

January 16, 2011

Pinal Dave

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

SQL Documentation, SQL Download

Size of the database is growing every day. Many organizations now a days have more than TB of the Data in their system. Performance is always part of the issue. Microsoft is really paying attention to the same and also focusing on improving performance for Data Warehousing. Microsoft has recently…

SQLAuthority News – Best Practices for Data Warehousing with SQL Server 2008 R2

January 15, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Data Warehousing, SQL Documentation, SQL Download

An integral part of any BI system is the data warehouse—a central repository of data that is regularly refreshed from the source systems. The new data is transferred at regular intervals by extract, transform, and load (ETL) processes. This whitepaper talks about what are best practices for Data Warehousing. This…

SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

January 14, 2011

Pinal Dave

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

SQL Scripts

Earlier I wrote SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine. That was the first article on the series of my real world experience of Performance Tuning experience. I have written second part the same series over here. Read second part over here: Quick…

SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name

January 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Quite often a simple things makes experienced DBA to look for simple thing. Here are few things which I used to get confused couple of years ago. Now I know it well and have no issue but recently I see one of the DBA getting confused when looking at the…