January « 2011 « SQL Server Journey with SQL Authority

Archive for January, 2011

SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Index, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 31, 2011 | 7 Comments »

Working in performance tuning area, one has to know about Index and Index Maintenance. For any Index the most important property is Fill Factor. Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which [...]

Read Full Post »

SQL SERVER – Denali – SEQUENCE is not IDENTITY

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on January 30, 2011 | 19 Comments »

Yesterday I posted blog post on the subject SQL SERVER – 2011 – Introduction to SEQUENCE – Simple Example of SEQUENCE and I received comment where user was not clear about difference between SEQUENCE and IDENTITY. The reality is that SEQUENCE not like IDENTITY. There is very clear difference between them. Identity is about single [...]

Read Full Post »

SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on January 29, 2011 | 8 Comments »

SQL Server 2011 will contain one of the very interesting feature called SEQUENCE. I have waited for this feature for really long time. I am glad it is here finally. SEQUENCE allows you to define a single point of repository where SQL Server will maintain in memory counter. USE AdventureWorks2008R2 GO CREATE SEQUENCE [Seq] AS [...]

Read Full Post »

SQLAuthority News – Deployment guide for Microsoft SharePoint Foundation 2010

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged SharePoint on January 28, 2011 | 4 Comments »

SharePoint and SQL Server both goes together – hands to hand. SharePoint installation is very interesting. At various organizations, the installation is very different and have various needs. SQL Server installation with SharePoint is equally important and I have often seen that it is being neglected. Microsoft has published the Deployment Guide for SharePoint Foundation. [...]

Read Full Post »

SQL SERVER – What is a Technology Evangelist?

Posted in About Me, Database, MVP, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged Evangelist on January 27, 2011 | 4 Comments »

When you hear that someone is an “evangelist” the first thing that might pop into your mind is the Christian church. In fact, the term did come from Christianity, and basically means someone who spreads the news about their faith. In the technology world, the same definition is true. Technology evangelists are individuals who, professionally [...]

Read Full Post »

Older Posts »