Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Nov 7th, 2011

I would use full-text indexing as you are on the latest version. Create and store the html in varbinary(max) column and set its associated file type to ".html" in a file type column. Then enable full-text index, so indexer will parse the data and search only the text content while ignoring the HTML tags. We had been using blob to store the documents, with the new features have come out in the later versions, this seems to be best option. We are in the process of migrating one of the app to use varbinary and to take advantage of the search feature. There is another way of storing using filestrem. Here is a good read-up from MS . FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data http://blogs.msdn.com/b/manisblog/archive/2007/10/21/filestream-data-type-sql-server-2008.aspx Here is another old report from MS back in 2006 explains about using oldway of BLOG http://research.microsoft.com/apps/pubs/default.aspx?id=64525 There are multiple options for you, pick the best approach that matches your needs Thanks, Suji

Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Apr 12th, 2011

WebSphere Application Server default ports

•Web container port (HTTP_TRANSPORT) - 9080
•Web container secure port (HTTPS_TRANSPORT) -  9443
•Administrative console port (HTTP_TRANSPORT_ADMIN) -  9090
•Adminstrative console secure port (HTTPS_TRANSPORT_ADMIN) -  9043
•Name service or RMI connector port (BOOTSTRAP_ADDRESS) -  2809
•Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) -  8880
•Data replication service client port (DRS_CLIENT_ADDRESS) -  7873
•Java Message Service (JMS) queued port (JMSSERVER_QUEUED_ADDRESS) -  5558
•JMS security port (JMSSERVER_SECURITY_PORT) -  5557
•JMS direct port (JMSSERVER_DIRECT_ADDRESS) -  5559
•Secure Association Services (SAS) SSL server authentication port (SAS_SSL_SERVERAUTH_LISTENER_ADDRESS) -  9501
•Common Secure Interoperability Version 2 (CSIV2) server transport port (CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS) -  9503
•CSIV2 client transport port (CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS) -  9502


WebSphere Deployment deployment manager default ports

•Administrative console port (HTTP_TRANSPORT_ADMIN) - 9090
•Adminstrative console secure port (HTTPS_TRANSPORT_ADMIN) - 9043
•Name service or RMI connector port (BOOTSTRAP_ADDRESS) - 9809
•Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) - 8879
•Data replication service client port (DRS_CLIENT_ADDRESS) - 7989
•Cell discover port (CELL_DISCOVERY_ADDRESS) - 7277
•Secure Association Services (SAS) SSL server authentication port (SAS_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9401
•Common Secure Interoperability Version 2 (CSIV2) transport port (CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9402
•CSIV2 transport port (CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS) - 9403
•Object Request Broker (ORB) listener port (ORB_LISTENER_ADDRESS) - 9100

WebSphere Application Server node agent default ports

•Name service or RMI connector port (BOOTSTRAP_ADDRESS) - 2809
•Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) - 8878
•Data replication service client port (DRS_CLIENT_ADDRESS) - 7888
•Secure Association Services (SAS) SSL server authentication port (SAS_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9901
•Common Secure Interoperability Version 2 (CSIV2) transport port (CSIV2_SSL_SERVERAUTH_LISTENER_ADDRESS) - 9101
•CSIV2 transport port (CSIV2_SSL_MUTUALAUTH_LISTENER_ADDRESS) - 9201
•Object Request Broker (ORB) listener port (ORB_LISTENER_ADDRESS) - 9900
•Node discovery port (NODE_DISCOVERY_ADDRESS) - 7272
•Node multicast discovery port (NODE_MULTICAST_DISCOVERY_ADDRESS) - 5000


WebSphere Application Server JMS server default ports

•Java Message Service (JMS) queued port (JMSSERVER_QUEUED_ADDRESS) - 5558
•JMS security port (JMSSERVER_SECURITY_PORT) - 5557
•JMS direct port (JMSSERVER_DIRECT_ADDRESS) - 5559
•Simple Object Access Protocol (SOAP) port (SOAP_CONNECTOR_ADDRESS) - 8876

Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Apr 12th, 2011

Command is - sudo gedit /boot/grub/menu.lst

This will show output as -
## default num
# Set the default entry to the entry number NUM. Numbering starts from 0, and
# the entry number 0 is the default if the command is not used.
#
# You can specify 'saved' instead of a number. In this case, the default entry
# is the entry saved with the command 'savedefault'.
# WARNING: If you are using dmraid do not change this entry to 'saved' or your
# array will desync and will not let you boot your system.
default 0

The important line is the last one. You will need to change that number 0 to match the Windows boot section. Typically it's always going to be 4 on a default dual-boot configuration. Change this value to 4, and then save and reboot your machine. You should go into Windows instead of Ubuntu automatically.

Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Nov 6th, 2011

Here are the Binary data types in sql server - bit, binary, varbinary, image. Bit variables store a single bit with a value of 0, 1 or NULL. binary(n) variables store n bytes of fixed-size binary data. They may store a maximum of 8,000 bytes. varbinary(n) variables store variable-length binary data of approximately n bytes. They may store a maximum of 8,000 bytes. image variables store up to 2 gigabytes of data and are commonly used to store any type of data file. Rest of the data types are non-binary

Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Apr 3rd, 2011

iframe is used for creating an inline or floating frame. As most of know frames are mainly used to structure the page or for placing a menu bar on the side and so on. But iframe is used in a different context. That is in other words <iframe> is used to embed or insert content on a page of padding. This is done for several reasons. Say the content may be large enough that the user may wish to place it separately and scroll through it. There are many attributes present in <iframe> and some of the attributes used with <iframe> are namely:

NAME:
Used for specifying the name of the frame.

SCROLL:
Used for specifying the scrolling action to be activated. Can take three values namely AUTO, YES or NO. AUTO will allow the browser to take the decision and activate scroll bar when needed YES specify scroll bar is needed and NO specifies scroll bar is not needed.

ALIGN:
This is used for alignment of text and the values that can be taken by it are namely LEFT, RIGHT, TOP, MIDDLE, and BOTTOM.

FRAMEBORDER:
Used for setting borders, around the frames if needed. A value of 1 set the border around the frame and 0 specify for no border.

HEIGHT:
Used to specify the height of the frame and this value is mentioned in pixels.

HSPACE:
Used for specifying horizontal spacing around the frames.

Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Nov 5th, 2011

Here are multiple ways to get the table information. The DESCRIBE command does not exist in MS SQL SERVER. This is an Oracle command used to describe the structure of objects within a given database. To achieve the same task in MSSQL Server, there are a series of stored procedures with the prefix SP_ that can be used. To view the structure of a table within the current database, use the command

Code
sp_help 'TABLE_NAME';

If you would like to see more details, Create your custom procedure

Code
CREATE procedure DESCRIBE 
(
@tablename varchar(256)
)
AS 
begin
SELECT DISTINCT sCols.colid AS 'order', sCols.name, sTyps.name, sCols.length
FROM [syscolumns] sCols
INNER JOIN [systypes] sTyps ON sCols.xtype = sTyps.xtype
INNER JOIN [sysobjects] sObjs ON sObjs.id = sCols.[id]
AND UPPER(sObjs.name) = UPPER(@tablename)
ORDER BY sCols.colid
end

Here is another alternative way to get the same information

Code
sp_columns 'TableName' (e.g. sp_columns 'Employee')
sp_columns [ @table_name = ] object [ , [ @table_owner = ] owner ] 
[ , [ @table_qualifier = ] qualifier ] 
[ , [ @column_name = ] COLUMN ] 
[ , [ @ODBCVer = ] ODBCVer ]

Here is the usage :

Code
EXEC sp_columns @table_name = 'Department', @table_owner = 'sa';
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'TableName'

Contributors for the editorial answer : Kewlshiva, srilakshmi.b, raaghav,kevaburg

Editorial / Best Answer

Answered by: suji

View all questions by suji   View all answers by suji

Member Since Sep-2005 | Answered On : Apr 3rd, 2011

"Describe yourself!", This question is almost invariably asked in the majority of interviews, and just as invariably answered dismally! What does one say and why do we always seem so flustered by the question? Because we have always been taught by our parents and respected elders not to boast or talk about ourselves.

With a childhood full of such repressive advice, its not surprising that the majority of us begin the answer with a stammer and a blush, almost instantly changing from flash to foolish and ruining our chances of employment.

So what do we say? Frankly, just answer the question as it comes. Most disconcerted candidates dread this question and begin with a silly "Basically, my name is ...". Why don't we realize that our CV is there right in front of the interviewer, and he knows this already.

By repeating the stuff that fills our CV, we just demonstrate that we are an 'in-the-box' kind of person, with little if any skill in innovation and presentation.

Actually, a question of this kind is an ideal way to plug in everything we want to say about ourselves that we had leave out of the CV. If you have attended a premier institution, say that the institution taught you much more than the degree it awarded you, mention people who influenced you, talk about the books you like reading, your hobbies and your other interests.

Talk about your strengths; perhaps mention an instance when you used your conflict resolution skills or selling skills or whatever. But make certain that it does not sound like blowing your trumpet. Mention these instances as learning.

Tall about your weaknesses, but make sure that they are 'positive' weaknesses. For instance you could say that that you sometimes pay more attention to detail than is warranted. You can openly confess a tendency to be impatient with team members who cannot carry their own weight, or who cannot contribute sufficiently.

But first, think today what you want to say and practice. Remember, if you hesitate about yourself, your interviewers will doubt whether you fit their bill of requirements. After all, if you don't know about you, who does?

How to describe yourself