September « 2010 « SQL Server Journey with SQL Authority

Archive for September, 2010

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

Posted in Best Practices, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 11, 2010 | 1 Comment »

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 bar for prerequisites and cross [...]

Read Full Post »

SQL SERVER – Find Automatically Created Statistics – T-SQL

Posted in Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SQL Statistics on September 10, 2010 | 4 Comments »

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 I would like to bring [...]

Read Full Post »

SQLAuthority News – Spicejet Complaint – Update – No Outcome

Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on September 9, 2010 | 8 Comments »

Few days ago, I wrote about SQLAuthority News – Spicejet Complain – Do Not Fly with Spicejet. I had written detail report to them with the name of the airport ground staff. I got response from them that they investigated everything and it was just normal delay. Everything was good. There were not issue at [...]

Read Full Post »

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

Posted in Best Practices, Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 8, 2010 | 13 Comments »

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 the same script to include [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Interview Questions and Answers, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 7, 2010 | 9 Comments »

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 the details on B-Tree and [...]

Read Full Post »

« Newer Posts - Older Posts »