Feeds:
Posts
Comments

Archive for December, 2009

Today is the last day of 2009 and this is my 1200th post! This year had been a wonderful year for me. I was actively involved with the community, and there were a lot of occasions where I could work along with IT professionals to resolve their issues in projects. Today, as this is my [...]

Read Full Post »

Recently, during my training session in Hyderabad, one of the attendees wanted to know the reason of the following error that he encountered every time he tried to create a view. He informed me that he is also creating the index using WITH SCHEMABINDING option. Msg 1949, Level 16, State 1, Line 1 Cannot create [...]

Read Full Post »

Today’s article is created based on wonderful contribution from Tejas Shah. Tejas is very prominent SQL Expert and .NET wizard. He has answered the query of a reader on this blog who raised the following question: how to generate the date for all the Sundays in the upcoming year. Tejas replied here with a script. [...]

Read Full Post »

Few days ago I wrote an article on the myth of table variable stored in the memory—it was very well received by the community. Read complete article here: SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth. Today, I am going to write an article which follows the same series; [...]

Read Full Post »

Here is the quick link from where SQL Server 2008 Express Edition can be downloaded. Download SQL Server 2008 Express Edition You can download it with many additional details as described in following image. Click on above link to go to page and select desired version. Additionally, please install SQL Server 2008 Express Service Pack [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers