SQL Server MVP and my very good friend Jacob Sebastian has written two wonderful articles about SQL Server and XML. I encourage to read this two articles to anybody who are interested in learning SQL and XML. Let us see how to Split a Delimited String.
SQLAuthority News – Tip of the Minute
Since my new personal website is launched I have received many comments and emails regarding new section of Tip of the Minute. Right navigation bar of the my personal website https://www.pinaldave.com/ contains section of the Tip of the Minute. Every time when page is refreshed it displays one new tip…
Read MoreSQLAuthority News – Happy Indepedance Day to India
India’s Independence Day is celebrated on August 15 to commemorate its independence on that day in 1947. The day is a national holiday in India. India will celebrate its 61st Independent day on August 15, 2008. Happy Independence Day to India Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – 2008 – Introduction to Online Indexing Operation
When index is created or recreated it usually decreases performance of database. Either SQL takes long time for response or it does not response at all as transactions are blocked. When new table or database goes live it is not possible to find out exactly how many indexes are needed.…
Read More
SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions
One of the reader Nanda of SQLAuthority.com has posted very detailed script of converting any date time in desired format. I suggest every reader of this blog to save this script in your permanent code bookmark and use it when you need it. Let us learn about User Defined Functions.
SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website
I am very pleased to announce my newly renovated website. I always liked my previous website as it was “Valid XHTML 1.1” and “Valid CSS 2.0”. Since I become MVP last month I have been receiving many emails where people were expecting more from my personal website. My blog http://www.SQLAuthority.com…
Read MoreSQLAuthority News – SQL Server 2008 Pricing and Licensing
Note: SQL Server 2008 Pricing and Licensing by Microsoft SQL Server licensing and pricing are to intervined subjects and very important. I strongly suggest to use properly licensed SQL Server in any production environment. The concept of licensing can be confusing sometime to new administrators. If there is any confusion…
Read More