SQL Server Interview Questions
Questions Answers Views Company eMail

How much memory that we are using in Logshipping Concept?

705

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 1957

If we shrink the Databse and Files, how much size is decreased?

TCS,

1 2075




What will you do If the low Performance occurs?

2 2090

Explain Capacity planning to create a database? and how to monitor it?

2804

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 5877

how we can use a database with php.

HCL, IT Solution,

2 1924

How retrieve field names from the table in SQL through JAVA code?

705




what is the maximum size of a row in sql server 2000 and 2005

2 2820

what is bit data type? and what are the information that can be stored inside a bit column?

2 2116

what are default? Is there a column to which a default cant be bound?

1 1618

what purpose does OPENXML clause have in sql server stored procedure?

1 3550

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 1881

Can store procedure call by user define function in SQL server?

HCL,

10 12077

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

Infosys,

8 5786


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

1256


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

773


How to trouble shoot if unable to connect SQL Server

766


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

881


Why do you want to join software field as you have done your BE in Electronics?

1024






What are the dis_advantages of stored procedures, triggers, indexes?

969


1 01 101 01010

742


If the job running very slow what is the action you do

714


Why we need to use secondry database file? though, we can do same work using primary database file also.

4215


how to overcome kernel isssues

468


Scalability, Availability, Integration with internet, etc.)?

1648


If user is owning any SQL Objects, can we drop that user

853


What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1578


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2676


How we create SQL Server 2005 Reporting Services ? Give me Sample

920