Answer Posted / sd

Bit datatype is used to store boolean information like 1 or
0 (true or false). Untill SQL Server 6.5 bit datatype could
hold either a 1 or 0 and there was no support for NULL. But
from SQL Server 7.0 onwards, bit datatype can represent a
third state, which is NULL.

How would you design a database for an online site, which would average a million hits a day?

1013

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2031

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1020

---

What is the database development process?

1226

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2170

---

What are the types of database model?

1097

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

1003

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2423

---

What is dbms explain in brief?

1032

---

Why does this query return 0?

1022

---

In which database can extended stored procedures be added?

906

---

How to read and create .LDC data files which are used by linguatic dictionary.

2531

---

Can an extended stored procedure be called from inside a user-defined function?

1055

---

Explain the process of the user request and data generating?

1094

---

How can I detect whether a given connection is blocked?

1055

---