SQL Server Interview Questions
Questions Answers Views Company eMail

How much memory that we are using in Logshipping Concept?

749

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

1 2024

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

TCS,

1 2130




What will you do If the low Performance occurs?

2 2129

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

2884

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

2 5975

how we can use a database with php.

HCL, IT Solution,

2 1967

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

741




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

2 2876

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

2 2175

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

1 1670

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

1 3671

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

1 1933

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

HCL,

10 12228

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 5978


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

979


last function used in MS Access to convert sql what function will use in sql

889


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

700


ow to bring suspect mode datbase online from scratch

724


optimization techinques

1387






what is difference between view and Dip.

1245


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

947


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

866


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1180


how to take backup bcp out for a column in table in sql server?

886


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

899


What is Lock table in SQL?

311


How can we call UDF(User Define Function) using C# code in ASP.net ?

4760


How do use Having,Group by,Group function in SQL?

705


application server is slow what may be the problem

1114