SQL Server from my eye - Hemantgiri S. Goswami

What is SP and How to write SP

2008-09-29T16:47:00Z

Hi, What is Stored Procedure(SP)? How to write Stored Procedure(SP) ? this is again a question which is asked by newbie/beginner and SQL Server Developer, Please refer below thread for the more details http://forums.surat-user-group.org/topic.asp?TOPIC_ID Read More......(read more)

should I shrink my database

2008-09-25T11:20:00Z

I have come across to the post "should I shrink my database" many times, this is certainly not recommended unless it is required. When we have ample space on the hard drive let it be in the size it is. Because what happens is when you shrink Read More......(read more)

New KB Articles on SQL Server 2005 and SQL Server 2008

2008-09-22T09:39:00Z

Here are link of new KB Articles released on SQL Server 2005 and SQL Server 2008 List of Builds that are released after SQL Server 2005 SP2 http://support.microsoft.com/kb/ 937137 / List of Builds that are released after SQL Server 2008 http://support Read More......(read more)

SQL Server 2008 - download November CTP now!!!

2008-01-11T07:54:00Z

SQL Server 2008 November CTP is available for download, click here to grab your copy of SQL Server 2008 Here are some more resources on SQL Server 2008 SQL Server 20008 Product Overview SQL Server 2008 Videos SQL Server 2008 White Papers SQL Server 2008 Read More......(read more)

MVP Again - New year gift from Microsoft

2008-01-07T06:01:00Z

I got my MVP award renewal for the 2nd year, this has been a wonderful gift on New Year. SQL Server from my Eye - Hemantgiri S. Goswami Read More......(read more)

Learn SQL Server 2008 from Microsoft

2007-11-12T06:26:00Z

Since some times their is a discussion on what's new in SQL Server 2008 , when the reference material will be available!! Here is an answer to this, Microsoft has introduce a course at its E-Learning, the course aims to educate IT Professional who Read More......(read more)

Merge Replication - Some Tips and Consideration

2007-10-26T08:57:00Z

* SQLAgent service should run under same domain account, which has local admin privilege and “Log in as a service” permission. This requires on both the server. In case, if SQL Server is not part of any Domain. We can use the user account which has identical Read More......(read more)

Estimating Table Size

2007-10-05T05:18:00Z

Many time it happens we were wrong with the Estimation of Table Size, wrong estimation of Row Size can trouble us with the growth of the database and ultimately we are ending up with the space crunch, and all this because of wrong Estimation of Table Read More......(read more)

Tunning Stored Procedure

2007-09-27T07:49:00Z

Most of the time I come accross the thread wherein user has requested to get started with stored procedure performance tunning , so here are some good reference material for tunning stored procedure http://www.sql-server-performance.com/tips/stored_procedures_p1 Read More......(read more)

My technorati profile

2007-09-21T09:52:00Z

My Technorati Profile SQL Server from my Eye - Hemantgiri S. Goswami Read More......(read more)

Automate Profiler Trace

2007-09-10T07:21:00Z

The question I recently come accorss on SQL Server Performance, the OP was asking on "How to automate profiler trace" , their are system stroed procedure that can be used to automate profiler trace. The system stored procedure you can use are Read More......(read more)

New KB articles are added for SQL Server 2005

2007-09-06T09:15:00Z

New Knowledge Base articles are added for SQL Server 2005, Here are the links FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005 FIX Read More......(read more)

Devcon2007 - A great Success

2007-09-05T06:46:00Z

Hi All, I am too glad... DevCon 2007 organized pune has great success, over 1100 attendes was recorded for this event. I thought this would the highest number of audiance till date , it includs IT professionals and students. Special thanks to all energetic Read More......(read more)

Renaming SQL Server that hosts Reporting Server

2007-08-23T05:16:00Z

Sometimes business demands or change in naming convention for servers lead to situation where one should change / rename the Server running MS SQL Server, it would not that panic renaming SQL Server as you have sp_dropserver and sp_addserver to help you, but what if this SQL Server box have reporting server too; well microsoft has workaround for it refer - http://technet.microsoft.com/en-us/library/ms345235.aspx

Resource for new SQL Server DBA and beginners in SQL Server

2007-08-20T08:19:00Z

" Give me some good resource that I can refer as new dba or beginner or new learner " this is the question asked by beginners and new learners in various forums I participate, thus I decide to post a blog referring the same, they are: Here are Read More......(read more)

DevCon - 2007 Organized by Pune User Group

2007-08-17T06:20:00Z

Read More......(read more)

Download System View Map for MS SQL Server 2005

2007-08-14T09:29:00Z

Read More......(read more)

Webcast on Reading Execution Plan and Query Tuning

2007-08-14T05:05:00Z

Read More......(read more)

hotfix or SP stops unexpectedly on SQL Server 2005

2007-07-30T10:30:00Z

Read More......(read more)

Failed to connecto to SSIS

2007-07-30T10:11:00Z

Read More......(read more)