Script to find fragmentation in MS SQL Server

This topic describes how to reorganize a fragmented index in MS SQL Server by using SQL Server Management Studio or Transact-SQL. The SQL Server Database Engine automatically maintains indexes whenever insert, update, or delete operations are made to the underlying data.

Read more

Script to rebulit Indexex in MS SQL Server

This topic describes how to reorganize or rebuild a fragmented index in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL. Heavily fragmented indexes can degrade query performance and cause your application to respond slowly.You can remedy index fragmentation by reorganizing or rebuilding an index. For partitioned indexes built on a partition scheme, you can use either of these methods on a complete index or a single partition of an index. Rebuilding an index drops and re-creates the index.

Read more

Notifications in iPhone

Notifications are an incredibly useful way to send messages (and data) between objects that otherwise don't know about each other. Think of it like a radio station broadcasting messages: the station (sender) broadcasts the message, and listeners can choose to listen in and receive some (or all) of the broadcast messages.

Read more

NSString - Objective-C Class Reference

As we've seen before, an NSString is an object that represents a block of text. The name presumably comes from the fact that it is a string of characters, though that is just supposition, but does make it slightly easier to remember.

Read more

Simple threading in iPhone

In iPhone / iPad development, executing code on a thread other than the main UI thread is usually done to keep a long running process from blocking or stalling the user interface. In iOS, there are a couple of ways to perform tasks on new threads. In this blog, we take a look at the simplest of these, NSThread.

Read more

Row Editing in DataGrid

We use data grid to display data in a grid format. With displaying data we also need to edit data. We can easily edit data grid row using java script functions and JQuery. To edit a row we have to select that row and apply editing. We can append, remove, accept and reject row.

Read more

Server Side Pagination in DataGrid

Server side paging(that is paging at the database layer by returning only the paged result) is very useful to display text in gridformat in a very fast speed. To get data grid we have to use method defined at the server side. We can define pagination and no of records shown at per page etc parameter.

Read more

Scan QR Code In Android

Zxing is a nice reader but it is not very easy to use for beginners as an implementation on Android projects, ZBar is a lot better. Not only is its scan speed and accuracy is astounding, it is insanely easy to implement as well. According to me than ZBar is a good alternative to Zxing. It is easy to install, it is easy to use and it works perfectly for all of the device .

Read more

Show Dots on Scroll Image in Android

I will show you how to create dots or little circles when you scroll the images. First you have to create a new project. After the project is created go to res -> drawable and put your images in the drawable folder. If you don't have a drawable folder you must create it by pressing right click - new directory and name it "drawable".

Read more

Benefits of LinkedIn

LinkedIn is a business-oriented social networking site which is primarily used for professional networking. It is a choice for working professionals to make more connections. Many tech-savvy business professionals, possibly even a majority of the business workforce, have profiles on LinkedIn and are connected to the social network a majority of the time. LinkedIn has been creating buzz in social media circles.

Read more