SQL Archives - Page 318 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Solid Quality Journal – Importance of Statistics

March 22, 2011

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

My article on “Important of Statistics” has been published in Solid Quality Journal. Statistics are a key part of getting solid performance. In this article we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like…

SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download

March 21, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Data Warehousing, SQL Documentation, SQL Download

I was recently working on learning various new stuff. I just would like to share very interesting resources here today. Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from any other data platform to SQL Server 2005, SQL Server…

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

March 19, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

After reading my earlier article SQL SERVER – master Database Log File Grew Too Big, I received an email recently from another reader asking why does the log file of model database grow every day when he is not carrying out any operation in the model database. As per the…

SQL SERVER 2008 – 2012 – Declare and Assign Variable in Single Statement

March 18, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Many of us are tend to overlook simple things even if we are capable of doing complex work. In SQL Server 2008, inline variable assignment is available. This feature exists from last 3 years, but I hardly see its utilization. One of the common arguments was that as the project…

SQL SERVER – Tell me What You Want to Listen – My 2 TechED 2011 Sessions

March 17, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Author Visit, TechEd, TechEdIn

I am going to present two sessions at TechEd India on March 25th, 2011. I would like to know what do you want me to cover in this session. Watch the video taken by my wife when I was preparing for the session. Sessions Date: March 25, 2011 Understanding SQL…

SQLAuthority News – I am Presenting 2 Sessions at TechEd India

March 16, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events, SQL Wait Stats

TechED is the event which I am always excited about. It is one of the largest technology in India. Microsoft Tech Ed India 2011 is the premier technical education and networking event for tech professionals interested in learning, connecting and exploring a broad set of current and soon-to-be released Microsoft…

SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer

March 15, 2011

Pinal Dave

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

SQL Scripts

My friend Jacob Sebastian has SQL Server Quiz 2011 launched. This time when he asked me to come up with quiz question – I wanted to come up with something which is new and make participant to think about it. After carefully thinking I come with question which I really…