Menu
Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
Sometimes you will need to disable an index, albeit temporarily. In order to disable an Index, make use of the following T-SQL Query: USE DatabaseNameGO ALTER INDEX NameOfIndex ON Table.Field
With the tag, you can scroll the text from top to bottom, from bottom to top, from left to right, from right to left, and you can also increase writing.
Web Workers allow you to run JavaScript code in the background without blocking the web page user interface. Web workers can improve the overall performance of a web page and
All data modifications of MySQL are updated onto logs in binary format. At times, if maintenance such as backup is not in place, and the data storage reaches the maximum
If you have two data tables with the same data columns, you can merge them quite easily. Merge Data Tables dataTableEuropeanCities and dataTableAsianCities are two datatables with same schema. They
You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not
You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not
for (float f = 10f; f!=0; f-=0.1){ System.out.println(f);} The code above causes an endless loop, it doesn’t act as expected, because 0.1 is an infinite binary decimal and f will
StringBuffer is a class that facilitates string operations and also helps reduce memory usage. A method defined on StringBuffer named setLength(int newLength) also serves as a shortcut to clear the
Download the Windows Media Encoder 9 Series x64 Edition Follow these simple steps: Click on New Session – Wizard – Capture Audio or Video File – Click Ok.Click on Properties
The null value often needs special attention in your code to work effectively. For developers, it is important to know if the value that was received for a query is
We can store data in the elements through HTML5’s data attributes. See below for an example on how to store and retrieve data from the data attributes. The values are
In equal comparisons it is recommended to place literals first. This way you eliminate the risk of NullPointerException: //avoid obj.equals(“foo”);//prefer”foo”.equals(obj);
Java long behaves differently when used with the letter L and without it. Code snippet public class JavaLong{ public static void main(String args[]) { JavaLong javaLong = new JavaLong(); javaLong.proceed();
The Debug.WriteIf?method allows you to write the debug to the listener only when a condition is true. See below for an example. Debug.WriteLineIc(counter ==100, “you have reached a maximum”);
This web design technique moves the background image at a different speed from the images in the foreground. Sample Code: Parallax Scrolling .parallax { background-image: url (???example.jpg???); height: 100%; background-size:
There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn’t support this. You will
There are many times when you are running on low memory and want to limit the data in your transactions. Especially, when you are sure that you don’t need all
We create a lot of break points during our development cycle and might get lost in them as well. One of the features of Visual Studio that is seldom used
Annotations are similar to interfaces in that you can convey your own specifications that others will need to follow. Here we are defining an Annotation named ClassHeaderAnnote, which has few
The SQL FORMAT() function is used to format how a field should be displayed. You can format dates in a column in the following manner: SELECT FullNames, Surname, UserID, FORMAT(Now(),’YYYY-MM-DD’)
Assuming you have a column in a table of type DATETIME, and you want to filter it based on dates and time as well, BETWEEN will be helpful. Listing 1.
LINQ queries follow deferred execution. This means when you access a LINQ query, it will get executed. If not well designed, it will execute every time you access it. In
InputStream in = new FileInputStream(file);int q;while ((q = in.read()) != -1) { …} The code above reads a file byte by byte. Every read() method call on the stream causes
The link tag in HTML supports the media element that allows you to specify the media type, and additional conditions such as the width and load a specified CSS file.
Sometimes you will have a situation where you would want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis (or any time increment
You can create a column in a table in MySQL and make that column to auto-increment the value every time a record is inserted in the table. The catch is
With C# 6.0, you can control exceptions with a conditional if. See below for an example: Listing 1. Control Exceptions try{ //Code that creates an exception}catch (System.DllNotFoundException dllEx) if (version
“” + set.size()new Integer(set.size()).toString() The return type of the Set.size() method is int, but it is desired a conversion to String. These two lines do the conversion, but the first
You can use IF NOT EXISTS?to check whether a Primary Key is missing and add it as follows: IF NOT EXISTS (SELECT * FROM sys.tables tINNER JOIN sys.schemas s ON
