SQL Server Interview Questions
Questions Answers Views Company eMail

How much memory that we are using in Logshipping Concept?

674

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

1 1899

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

TCS,

1 2027




What will you do If the low Performance occurs?

2 2038

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

2742

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

2 5804

how we can use a database with php.

HCL, IT Solution,

2 1869

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

672




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

2 2763

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

2 2037

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

1 1570

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

1 3496

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

1 1831

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

HCL,

10 11956

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 5677


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

825


what exactly sql injuction.how to overcome.....

1285


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

772


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1124


How to trouble shoot if unable to connect SQL Server

743






how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1034


what is checksum in sql server.........???

357


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

886


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.

1543


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.

748


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

914


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

1472


SQL Server Architecture ?

1101


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1226


New concepts of sql server 2005 use in your project.

1211