SQL Server from my eye - Hemantgiri S. Goswami

What is SP and How to write SP

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 29 Sep 2008 16:47:00 GMT

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)

should I shrink my database

SQL Server from my Eye - Hemantgiri S. Goswami — Thu, 25 Sep 2008 11:20:00 GMT

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)

New KB Articles on SQL Server 2005 and SQL Server 2008

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 22 Sep 2008 09:39:00 GMT

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)

SQL Server 2008 - download November CTP now!!!

SQL Server from my Eye - Hemantgiri S. Goswami — Fri, 11 Jan 2008 07:54:00 GMT

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)

MVP Again - New year gift from Microsoft

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 07 Jan 2008 06:01:00 GMT

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

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 12 Nov 2007 06:26:00 GMT

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)

Merge Replication - Some Tips and Consideration

SQL Server from my Eye - Hemantgiri S. Goswami — Fri, 26 Oct 2007 08:57:00 GMT

* 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)

Estimating Table Size

SQL Server from my Eye - Hemantgiri S. Goswami — Fri, 05 Oct 2007 05:18:00 GMT

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)

Tunning Stored Procedure

SQL Server from my Eye - Hemantgiri S. Goswami — Thu, 27 Sep 2007 07:49:00 GMT

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)

My technorati profile

SQL Server from my Eye - Hemantgiri S. Goswami — Fri, 21 Sep 2007 09:52:00 GMT

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

Automate Profiler Trace

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 10 Sep 2007 07:21:00 GMT

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)

New KB articles are added for SQL Server 2005

SQL Server from my Eye - Hemantgiri S. Goswami — Thu, 06 Sep 2007 09:15:00 GMT

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)

Devcon2007 - A great Success

SQL Server from my Eye - Hemantgiri S. Goswami — Wed, 05 Sep 2007 06:46:00 GMT

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)

Renaming SQL Server that hosts Reporting Server

Goswami — Thu, 23 Aug 2007 05:16:00 GMT

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

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 20 Aug 2007 08:19:00 GMT

" 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)

DevCon - 2007 Organized by Pune User Group

SQL Server from my Eye - Hemantgiri S. Goswami — Fri, 17 Aug 2007 06:20:00 GMT

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

Download System View Map for MS SQL Server 2005

SQL Server from my Eye - Hemantgiri S. Goswami — Tue, 14 Aug 2007 09:29:00 GMT

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

Webcast on Reading Execution Plan and Query Tuning

SQL Server from my Eye - Hemantgiri S. Goswami — Tue, 14 Aug 2007 05:05:00 GMT

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

hotfix or SP stops unexpectedly on SQL Server 2005

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 30 Jul 2007 10:30:00 GMT

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

Failed to connecto to SSIS

SQL Server from my Eye - Hemantgiri S. Goswami — Mon, 30 Jul 2007 10:11:00 GMT

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