Feeds:
Posts
Comments

Archive for September, 2010

SQLAuthority News – What is an MVP? – How to become an MVP?

Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 16, 2010 | 7 Comments »

There are a lot of basic questions I get that inquires about being an MVP. Some of them include: What is an MVP? How can I become an MVP? Are there any exams needed before becoming an MVP? Does an MVP get paid? Is it compulsory for MVPs to promote Microsoft Technology? and many more… [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL View, T SQL, Technology on September 15, 2010 | 11 Comments »

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… This is very well known limitation of the View. Once the view is created and if the basic table has any column added or removed, it is not usually [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 14, 2010 | 5 Comments »

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 the next level. I have [...]

Read Full Post »

SQL SERVER – What are Wait Types, Wait Stats and its Importance

Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 13, 2010 | 4 Comments »

Earlier last month Solid Quality India announced SQL Server Health Check Service and since then, it has got very good response from the industry. However, the only question we are be asked all the time is: “What is “SQL Server Resource Wait Stats Analysis” and how can it be useful?”What caught my attention is that [...]

Read Full Post »

SQL SERVER – Soft Delete Conversation – Your Opinion Needed

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Optimization, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 12, 2010 | 4 Comments »

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 am listing today here few [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers