(Eddie Awad) In SQL and PL/SQL there are two comment styles you can use, single-line and multi-line: –Multi-line comments begin with a slash and an asterisk (/*) and end with an asterisk and a slash (*/). the comment can span multiple lines. –single-line comments begin with — (two hyphens)
Other News
The MySQL Optimal Configuration Architecture (MOCA)
(George Trujillo) I am a firm believer in establishing best practices for database management and following them. As your databases grow in numbers and size, it becomes critical to establish best practices for your database management. I was asked recently to write down some of these best practices
Flexible Row Generator with Oracle 11g Unpivot Operator
(Lucas Jellema) Row generation is a very useful technique for many (semi-)advanced SQL Queries. We have discussed various methods for row-generation in previous articles on our weblog. Examples are the CUBE operator, Table Functions and the Connect By Level < #number of records approach, apart from [membership level="0"] [pmpro_button level="14" text="Read More - Register for Free Membership"][/membership] [membership][standout-css3-button href="http://technology.amis.nl/blog/?p=2419" opennewwindow=true]Read […]
Optimize SAN setup for improved SQL Server performance
(Serdar Yegulalp) Storage area networks, or SANs, are widely used to store data for Microsoft SQL Server installations with large databases. SANs are one of the most economical ways to deal with very large data sets. They’re designed to scale better in this regard than disk arrays installed directly
DefaultMember, subcubes and non-aggregatable attributes
(Marco Russo) Today I discovered that DefaultMember might result in a member other thant the default dimension member.
See SQL Server graphical execution plans in action
(Tim Chapman) Execution plans are one of the best tools to use to tune your SQL Server queries. In this article, I identify a few basic things to look for in a graphical execution plan to help you better understand how SQL Server uses indexes. I also offer ideas about how to make your queries faster
SQL Server server and Databases Health check process
Featured Article(s) SQL Server server and Databases Health check process The following stored procedure is really a collection of several TSQL system procedures designed to monitor server and databases configuration values and keep the DBA Informed about databases health Want to manage multiple implementations of the same database? Want to build stored procedures in seconds? Auto generate SQL Delete, Update […]
Navigate hierarchical site data with ASP.NET’s TreeView control
(Tony Patton) Now that you’re up to speed on ASP.NET Site Map and SiteMapPath controls, I’ll explore the TreeView control, which gives users an easy way to navigate a Web application. I will begin with an examination of the SiteMapDataSource control, which you may use to populate the TreeView contro
Weaving WebSphere: Installing WebSphere Express 6.1
(Joe Pluta) I recently did my very first scratch install of i5/OS. And while IBM provides really good instructions for doing so, the nature of the process is such that a first-timer can get a bit uneasy even when things are going correctly. For example, there were places where the documenter knew th
Using Hidden Column in af:table Component
(Andrejus Baranovskis) Quite often you may face requirement, when you will need to use hidden column in af:table component. Such requirement could be to insert into database, along with values provided by the user, some another value automatically. This value is not visible for the user and is inser