SQL Server - Truncate tables in a SQL Server database

Problem As a DBA I have found many occasions in testing of various SQL Server deployments and scripts where I need to load a database with data from a lower environment or where I need to alter a table that might already have data in it in such a way that I need to first eliminate the data before I can proceed. Depending on the foreign key constraints in place, clearing old data can be a tedious process. Solution When I don't care about existing...

Read More

Change the COLLATION of a SQL Server Column

Problem You've installed SQL Server with all the defaults, created your database and schema then loaded a bunch of data into your database. Now you realize that some or all of the columns in your database needed to have the COLLATION set to be case sensitive. This tip will take you through the steps required to change the column COLLATION of your tables from SQL_Latin1_General_CP1_CI_AS to SQL_Latin1_General_CP1_CS_AS. Solution Table Setup Let's first setup a couple of tables in order to walkthrough these steps required to update the column...

Read More

Delphi - Records

What are records? Records are a useful and distinguishing feature of delphi. They provide a very neat way of having named data structures - groups of data fields. Unlike arrays, a record may contain different types of data. Records are fixed in size - the definition of a record must contain fixed length fields. We are allowed to have strings, but either their length must be specified (for example a : String[20]), or a pointer to the string is stored in the record. In this case, the record cannot be used to write the string to a file....

Read More

Developing Facebook Fan Page Requires Effort and Creativity

At this point of time, each and every individual is aware about Facebook. Promoting your products as well as services have become very necessary in today's business scenario and for that Facebook is one of the finest platforms. Either you must already be having a Facebook Fan Page for your business, or you must be planning to create a new one. Nowadays, it has become really very important to make use of these social networking sites to their fullest prospective. Moreover, setting up a Fan Page is not just the only activity; it must be customized...

Read More

SQL Server - OLE DB Deprecated :(

As you may already know, the SQL Native Client OLE DB provider is being deprecated. This doesn't affect other OLE DB providers or the OLE DB API. Also, the SSIS OLE DB components are not being deprecated. In SQL Server 2012 SSIS, you can continue to use OLE DB connections and will need to for components such as the Lookup transformation and the Slowly Changing Dimension transformation that require OLE DB. In the post-Denali release, you’ll be able to upgrade and continue to operate these packages without needing to do additional work to explicitly...

Read More

SQL Server - Result paganation in sql server

A lot of SQL Server database users at some time faced a big obstacle, especially web sites programmers when need to read data from the database in case of a partial data was a fairly large size. After a long and arduous journey made in the search for the best method that can solve the problem very haunting, I've experimenting with dozens of ways that were not satisfactory at first, especially if the data is very large size. In fact,i did't...

Read More

PHP -MySQLCrank

MySQLCrank Provides a number of functions to make it easier to work with MySQL databases, without using a lot of mysqli_xxxx functions, making it easier to switch to a different database. Supports SELECT, INSERT, UPDATE, and DELETE queries only, first because of security reasons, second - other queries are just not really needed for web development.  Using MySqli_ extension (as described in php.net): The mysqli extension, or...

Read More

SQL Server - Table Partitioning technique

Technical concept : partitioning in simple word is spreads your data in multi file groups , file groups it's physical files on your Hard drive . Usage: This technique is used heavily in case of very large tables which are hard to get rid of this data on a regular basis, so it would be difficult to work out on the tables of millions of data that are used only when needed. Therefore stems need to provide a mechanism to keep all the data available,...

Read More

PHP - Steps to increase the efficiency of PHP code

If you're a developer, it is necessary for you to improve your script in the development process itself early. Following the best practices while coding your PHP script is a good starting point to write PHP code optimization as well. This tutorial provides few tips to optimize PHP code from a developer point of view. 1. Use Native PHP Functions As much as possible, try to use the functions of the original PHP instead of writing your own functions to achieve your goal. For example, you can use range (b, k) to get of alphabets ranging from...

Read More