Database operations often tend to be the main bottleneck for most web applications today. It’s not only the DBA’s (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.
There are many ways to do this in SQL Server,Here i will show you the one of the way to Convert a column of the table into Comma separated string using FOR XML PATH in query.
SQL is yet another essential language for developers wishing to create data-driven websites. However, many developers are unfamiliar with various aspects of SQL; so in this article, we’ll analyze ten essential tips.
Copyright © 2012 - Nestdev.com all Rights Reserved
Proudly powered by WordPress and Tricks Theme designed by: Tricks-Collections.Com