Enigma

New Group for SQL Server DBA's

http://groups-beta.google.com/group/MSSQLServerDBA

Yeah ... I know !!! There are too many groups existing all over the internet ... but adding another one wont make much of a difference

Asking all SQL Server DBA's to join in ... I will be keeping the membership open for five days and after that it will be moderator approved. I would like to create a like minded community where we can all talk about SQL Server 2005 and how to work our way towards it .... or in other words ... as put very well by Kent ... We must bridge Yukon together 

KENT ... i hope you will be the first one to join ...

	Subscribe to SQL Server DBA
	Email:
	Browse Archives at groups-beta.google.com

Ok !!! I've waited too long now :)

Longing for a Gmail Account

I have been longing to get a gmail account but no invite so far ...

Today morning I see that Tejas got an account by blogging about it ... I am gonna try it out too :p

From reading comments on Tejas's blogs ... I remember now that that prior to this Marcie (yeah, the DataGridGirl ) did the same thing... and got an invite too ...

So all those guys and gals reading my weblog ... (I m sure there are not many )... if anybody can get me one, please send me an invite ...

Lets see how much this helps ;)

Another SQL Blogger arrives

Another SQL Blogger Arrives

A good friend of mine, and a fellow SQL DBA, Amit Jethva has joined the community of bloggers at SQL Junkies.

http://sqljunkies.com/WebLog/amitjethva/Rss.aspx

Welcome Amit, Hoping for some nice insightful posts from you ...

Including Images in RSS feeds

Ramblings :Including images in RSS feeds

I am a guy who is mostly on Dial-up connection while viewing my blog roll. The vast amount of info published on weblogs is overwhelming enough.

I agree with Scoble on his view that the entire text  should be included in the feed, coz I would not like to make use of additional bandwidth for getting the complete text or visiting the site for reading the entire post. What I dislike though, is including images in the RSS feed.

Take the case of today, there are a lot of bloggers talking about their experience at TechEd San Diego and almost 40% have posted images back on their posts. I am not interested in viewing those images and nor reading about where a guy is staying or where he will be availible during Teched. Now the text part from their posts is acceptable, coz text download size as compared to image download size is very less. Forcing the image in the feed takes up a lot of my bandwidth.

So, any votes for removing images from the RSS feed ? Feel free to leave your comments.

Page Allocation Error - SQL Server

Harshal, a friend of mine just had an error where he was not able to increase the size of database and the server gave an error  .

Could not allocate new page for database 'rough'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth

Error 5149: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file

The disk had ample free space but it seemed like SQL Server was not able to see it. While troubleshooting this, the magic figure of 4095 MB (2³² bytes minus 1 byte)pointed me to the solution from long ago from the days of FAT16 and FAT32 filesystems.

The solution for the benefit of anybody who might encounter such a problem is :

FAT32 does not support files greater than 4 GB.

So convert your disk to NTFS, if you need files greater than 4 GB.

PS : I am still waiting for a confirmation of the solution ... but I am willing to bet on this solution ...

Need feedback for an Article ???

Have been working on an article on datetime datatype and its manipulation to achieve desired results. Need feedback on what kind of problems are common with developers ...

Few I have identified as per my experience in various forums ..

Getting only date/time part from a datetime column

Errors converting from varchar to datetime.

What are the common problems that you encounter ??? Leave your comments and I will try to address as many of the problems as possible in the article ...