http://netvouz.com/tag/sql?feed=rss&pg=11 Bookmarks tagged with "sql" on Netvouz http://sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk elsimono Sat, 16 Dec 2006 10:13:12 GMT http://www.databasejournal.com/features/postgresql/article.php/3437821 There is an understanding in the database world that using a 'SELECT DISTINCT' SQL query is not a good idea, because it is essentially getting duplicate rows out of the database and then discarding them. Usually it's better to rearrange the 'WHERE' clause in the query to only get the rows you need. Tom Copeland gives a step-by-step 'case study' of analyzing a query in PostgreSQL and how to ensure that your SQL rewrite is actually paying off. programming > sql postasaurus Tue, 12 Dec 2006 10:12:10 GMT http://www.wellho.net/mouth/158_MySQL-LEFT-JOIN-and-RIGHT-JOIN-INNER-JOIN-and-OUTER-JOIN.html the differences between mysqls different joins explained schmilblick Tue, 21 Nov 2006 13:37:45 GMT http://www.bdiez.com/spanish.htm Braulio Diez Personal Page, .net and SQL Server tips and tricks. Informacion gabinortega Sat, 18 Nov 2006 02:06:10 GMT http://www.bcarter.com/sap20.htm Replace OR With UNION OComputers > Programming > Languages > SQL fni Thu, 19 Oct 2006 14:15:52 GMT http://www.cql.com/sqllang.html OComputers > Programming > Languages > SQL fni Thu, 19 Oct 2006 14:15:52 GMT http://support.microsoft.com/support/kb/articles/Q153/4/49.ASP INF SQL Server Code Pages and AutoAnsiToOem Behavior Computers > Software > OCharacter Encoding fni Thu, 19 Oct 2006 14:15:31 GMT http://www.sqlservercentral.com/ Microsoft SQL Server community with 375,526 Microsoft SQL Server users kapluni Mon, 16 Oct 2006 18:23:09 GMT http://www.davidhayden.com/davidhayden/articles.aspx ADO.NET ASP.NET Enterprise Library Design Patterns SQL Server C# touch > refrence creaturez Fri, 13 Oct 2006 06:32:36 GMT http://msdn2.microsoft.com/en-us/library/ms187928.aspx kapluni Thu, 12 Oct 2006 20:48:01 GMT