03-May-2013
SQL Yoga – Read XML with T-SQL statement in SQL SERVERIn my previous post, “XML Result sets with SQL Server”, we review to generate result sets in XML from SQL server. Then I got a comment from the team, to also have post to read XML in SQL Server.
14-May-2013
SQLYoga – XML Result sets with SQL ServerRecently, found that people making much complex code to have an XML in application. I have found that they return result set in Table to the application and have applied code to convert that data table to XML by Asp. Net application. When I review the process, I have suggested that why don’t you use the XML feature of the application. They surprised the simple use of it and make their life easy. Let me have sample query to generate XML result sets in SQL Server database.
29-Oct-2012
SQL SERVER: T-SQL to find out when database was restoredRecently, we have found that our testing database has been restored on the server and we lost our recent work. We have to identify that at what time the database has been restored, so we can know that what are the changes need to be restored again on the database
23-Aug-2010
SQL SERVER: Find executing queriesRecently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details.
09-Dec-2008
SQL SERVER: How to Add Computed ColumnToday I came across scenario where I need to add one computed column. Computed column means we can manipulate one or more column from the same table and we can use this column in queries as regular column.
23-Dec-2009
SQL SERVER: How to Read Excel file by TSQLMany times developers asked that, they want to import data from Excel file.
28-Dec-2009
SQL SERVER: How to remove cursorMany times developer ask me that How can they remove Cursor?
09-Oct-2009
Community TechDays at Ahmedabad - Great EventThere was a great event held by Microsoft and PASS (Professional Association of SQL Server) in Ahmedabad on 3rd October 2009. This was very big event where 250+ attendees attend the excellent session of Vinod Kumar, Pinal Dave, Jacob Sebastian and Prabhjot Singh Bakshi. There were Four technical sessions by these excellent speakers.
22-Jul-2009
SQL SERVER: Reset Setup Values, when SQL SERVER is started/restartedWe have a requirements to clear all setup values when SQL SERVER is started/restarted and we need to setup default values to setup table.
