...
2/23/2007
2/20/2007
Difference between Stored Procedure and Function (UDF)
Functions can be used with Select statementNot returning output parameter but returns Table variablesYou can join UDFCan not be used to change server configurationCan not be used with XML FOR clauseCan not have transaction within functionStored Procedurehave to use EXEC or EXECUTEreturn output parametercan create table but won’t return Table Variablesyou can not join SPcan be used to change server configurationcan be used with XML FOR Clausecan have transaction within ...
New Version Microsoft SQL Server 2005 SP2 and Books On Line release
New version of SQL Server 2005 SP2 & SQL Server 2005 Books Online (BOL) released and now available at http://www.microsoft.com/sql/sp2.ms...
2/17/2007
Disappearance of Jim Gray
Hi,If you are participating in community activity regularly you must aware of Jim Gray a great guy, he is disappear near Farallon Islands: Help searching Jim Gray, a known Database Guruhttp://blogs.msdn.com/dtjones/archive/2007/02/03/how-you-can-help-in-the-search-for-jim-gray.as...
2/07/2007
Remote Deployement of SQL Server
Hi All,When it comes to deploying a SQL Server Remotely with Sharepoint service, we just think and search around to get the answer how do i?!!!Here is a very good article on the Remote Deployment of SQL Server with Sharepoint Services, Refer http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc02.mspx?mfr=true for more.RegardsHemantgiri S. GoswamiMicrosoft SQL Server MVP"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"Disclaimer: This postings is provided "AS I...
2/05/2007
SQL Server : TO Blob or Not
Hi All,In many community forums i participated i found many users ask a querstion on BLOB datatype. That is "Is it okay if i do store binary files / images / documents store in SQL Server Database?" . The answer is no.....it is always good to store the location of the Binary Files or Documents Or Images and let it handled by Front End application. Here is a wonderfull research paper published on Microsoft Site http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45RegardsHemantgiri S. GoswamiMicrosoft SQL Server...
New Year Gift from Microsoft
Hi All,I am honored Microsoft Most Valuable Professional in Windows Server System - SQL Server Competency for year 2007. A wonderfull gift from Microsoft.Hemantgiri S. Goswa...
"Katmai" - Next Version of SQL Server
Hi All,Microsoft officials has announced in their blog at ZDNET website, They code name it "Katmai" that would be next version of Microsoft SQL Server and that's not just a SQL Server but more then that. Read more on it http://blogs.zdnet.com/microsoft/?p=217RegardsHemantgiri S. GoswamiMicrosoft SQL Server MVP"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"Disclaimer: This postings is provided "AS I...
