How to loop through result set objects using mssql_fetch_array()?
No Answer is Posted For this Question
Be the First to Post Answer
Can you explain the types of Joins that we can have with Sql Server?
Can we drop user if user mapped to any logins
What are the steps you will take to improve performance of a poor performing query?
What kind of problems occurs if we do not implement proper locking strategy?
How to tune a stored procedure?
Can you pass expressions to function parameters?
how can i lock the column in the table
query processing
What is the partitioning method?
how do we find every fifth record in a table
Will sql server 2005 allow you to reduce the size of a column?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)