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

SQL SERVER – Soft Delete Conversation – Your Opinion Needed

September 12, 2010

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

Last Week I wrote article about SQL SERVER – Soft Delete – IsDelete Column – Your Opinion and this article has got excellent community response. There have been some very interesting feedback on both the side. There are few opinions where expert have explained the conversation very balanced way. I…

SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper

September 11, 2010

Pinal Dave

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

Best Practices, SQL Documentation, SQL Download

I had previously written article on SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial. Microsoft has come up with white paper regarding same Best Practice Analyzer. In the new R2 version the SQL BPA introduces advanced capabilities in conjunction with the PowerShell architecture and also raises the…

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 – Few Notes on Fast Track Data Warehouse

September 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data Warehousing

I recently delivered fast track data warehouse training. This training was very challenging as this training requires very specific hardware and extremely different way of looking at data warehousing. While training I have made few notes and I will now share the same notes with you. Please note that this…

SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me

September 4, 2010

Pinal Dave

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

Best Practices

No story today – I am sure all of you know what I want to talk today. I am indeed not happy with how social media is evolving. There was a time when every social media has its own style and concept. Today wherever I go, I see the same…