dev-exchange.com

How to reindex a table index data?

net guru — Thu May 08, 2008 4:00 pm

Author: net guru

Posted: Thu May 08, 2008 4:00 pm

Sorry for a very late response to this post.
You can use DBCC DBREINDEX command to reindex your table data.

Code:

DBCC DBREINDEX('table','index','fillfactorpercentage');

looping through comma seperated values in SQL server 2005

Jacobs — Fri May 02, 2008 9:29 am

Author: Jacobs

Posted: Fri May 02, 2008 9:29 am

Hello,

I need to loop through a comma seperated list of ids and insert them in database. How do i do this easily?

Thanks

converting a string value to integer in java script

Daniel — Thu May 01, 2008 2:26 pm

Author: Daniel

Posted: Thu May 01, 2008 2:26 pm

Kish,

Thanks for the advice. parseInt() worked for me.

Freelance.eu outsource your programming and webdesign projec

adminfreelance — Tue Apr 15, 2008 8:15 am

Author: adminfreelance

Posted: Tue Apr 15, 2008 8:15 am

http://www.freelance.eu
freelance, programming, outsourcing, programmer, outsource, php programming, mysql,mysql database database
Freelance.eu , temporarily: post your projects for free and free webmaster and programmer signup!

New people search engine launched

Nirmal Kamath — Sun Mar 16, 2008 7:04 am

Author: Nirmal Kamath

Posted: Sun Mar 16, 2008 7:04 am

Hi friends,

Let me say something about our new product. Have a look at this site. http://www.kittipoi.com/

Through this site, you can find people all over the globe. just you need to type your friend's name and click on search.

Our search engine looks for people in social networking sites, blogs and other online networks from all parts of the world, where ever they are.

Find your long lost friends in one click rather than scouring through numerous sites. Our search engine does this in a blink.

Cheers,
Nirmal Kamath

Inserting tick box to microsoft excel sheet

tella.star — Mon Mar 10, 2008 1:05 pm

Author: tella.star

Posted: Mon Mar 10, 2008 1:05 pm

click in the cell. drop down the "insert" pull down menu. and select "symbol". then choose the tick box.

if you want to make it "ticked" type an x in the cell, if you want it "unticked" type an o in the cell.

How to change IP address?

tella.star — Mon Mar 10, 2008 1:01 pm

Author: tella.star

Posted: Mon Mar 10, 2008 1:01 pm

1. Get to the Microsoft Windows desktop.
2. Right-click on My Network Places or Network Neighborhood and click Properties.
3. Right-click on Local Area Connection and click Properties.
4. Click Internet Protocol (TCP/IP) and click Properties. If this is not present, you'll need to install this protocol.
5. In the Internet Protocol (TCP/IP) Properties window, select "Use the following IP address" if not already selected and specify the new IP address you wish to use. While entering this data you'll also need to specify the subnet mask and default gateway.

finding IP location

tella.star — Mon Mar 10, 2008 12:54 pm

Author: tella.star

Posted: Mon Mar 10, 2008 12:54 pm

http://www.geobytes.com/IpLocator.htm?GetLocation is a good link too. but phaster is alot better.

Restricting an empty string using XML schema

Techie — Fri Mar 07, 2008 1:23 pm

Author: Techie

Posted: Fri Mar 07, 2008 1:23 pm

Add this code in your schema file and refer the name in type:

Code:

<xs:simpleType name="nonemptystring">
<xs:restriction base="xs:string">
<xs:minLength value="1" />
</xs:restriction>
</xs:simpleType>

Calling this

Code:

<xs:attribute name="yourattribtename" use="required" type="nonemptystring" />

link farm

Daniel — Sat Mar 01, 2008 11:18 pm

Author: Daniel

Posted: Sat Mar 01, 2008 11:18 pm

tella.star, thanks for your comment on this.

Syntax for backing UP a SQL server database

Kishore — Thu Feb 28, 2008 12:22 pm

Author: Kishore

Posted: Thu Feb 28, 2008 12:22 pm

here is the syntax:

Code:

BACKUP DATABASE <Database_Name, sysname, Database_Name>
TO DISK = N'<Backup_Path,,C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\><Database_Name, sysname, Database_Name>.bak'
WITH
NOFORMAT,
NOINIT,
NAME = N'<Database_Name, sysname, Database_Name>-Full Database Backup',
SKIP,
STATS = 10;
GO

Validating a date in JS

Jacobs — Wed Feb 27, 2008 9:50 am

Author: Jacobs

Posted: Wed Feb 27, 2008 9:50 am

Thanks Kish for this JS code

Validate a big integer in CF8

Andy — Thu Feb 21, 2008 4:06 pm

Author: Andy

Posted: Thu Feb 21, 2008 4:06 pm

Hello net guru, thanks for isValid regex tip.

CFC remote error

net guru — Mon Feb 18, 2008 2:03 pm

Author: net guru

Posted: Mon Feb 18, 2008 2:03 pm

Daniel, this link may be useful as well

http://www.feed-squirrel.com/index.cfm?evt=viewItem&ID=2322

DateTime column select query is slow on SQL server

Kishore — Sun Feb 17, 2008 4:24 pm

Author: Kishore

Posted: Sun Feb 17, 2008 4:24 pm

You can create another index on date field which may speed up things.