SQL Scripts Archives - Page 224 of 318 - SQL Authority with Pinal Dave

SQL SERVER – How to Stop Growing Log File Too Big

September 20, 2010

I was recently engaged in Performance Tuning Engagement in Singapore. The organization had a huge database and had more than a million transactions every hour. During the assignment, I noticed that they were truncating the transactions log. This really alarmed me so I informed them this should not be continued…

SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4

September 15, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL View

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more…

SQL SERVER – Disabled Index and Index Levels and B-Tree

September 14, 2010

Pinal Dave

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

SQL Index, SQL Scripts

This blog post is written in response to T-SQL Tuesday hosted by Michael J. Swart. Recently, I presented a session at the Microsoft Bangalore office. Everybody eagerly wanted to learn more, to the extent that they wanted a mentor to train each of them in order to move on to…

SQL SERVER – Find Automatically Created Statistics – T-SQL

September 10, 2010

Pinal Dave

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

SQL Scripts, SQL Statistics

Earlier, I wrote about my experience at an organization here: SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script. This blog post briefly narrates another experience I had at the same organization. When I was there, I also looked at the statistics and found something that…

SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2

September 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, SQL Scripts

Last Year I wrote article on the subject SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL. It is very good to see excellent participation there. In my script I had not taken care of table schema. SQL Server Expert Ameena has modified…

SQL SERVER – Index Levels and Delete Operations – Page Level Observation

September 7, 2010

Pinal Dave

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

SQL Index, SQL Scripts

I wrote an article before on SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats. In that article, I promised that I would give a follow up post with a few more interesting details. I suggest that you go over the earlier article first to understand…

SQL SERVER – Index Created on View not Used Often – Limitation of the View 3

September 6, 2010

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL View

Update: Please read the summary post of all the 11 Limitation of the view SQL SERVER – The Limitations of the Views – Eleven and more… Let us learn about Index Created on View not Used Often.