SQL Server Interview Questions
Questions Answers Views Company eMail

What is a NOLOCK?

3 16961

How do SQL server 2000 and XML linked?

2 5901

What is the difference between HAVING clause and the WHERE clause?

7 11703




Explain what are db_options used for?

InterGraph,

1 7096

how to know description of a table in sqlserver 2000

8 5899

plz send every query in sql server2000

Infosys,

1 3192

How to Execute an Operating System Command From Within SQL Server ?

3 5493

How can I create a plain-text flat file from SQL Server as input to another application?

2 8829




Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

Infosys,

3 6325

The Difference between 'Count' and 'Count(*)'

13 16837

How do I list the available tables in a database I'm querying?

4 3764

How to count the number of duplicate items in a table?

3 5401

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 3060

How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

GE,

1 3343

Is it possible to create tables in stored procedures using a variable for the table name?

2 3126


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what is difference between view and Dip.

1139


ow to bring suspect mode datbase online from scratch

644


What is RMS migrations?

902


whats new about truncate in sql server 2008?

1256


application server is slow what may be the problem

1048






Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1305


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2628


what are the Prerequisites for Replication?

8233


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

530


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

867


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

737


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

573


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

830


Which is the best place or learning center for MS SQL?????In Bangladesh?????

829


whats the maximum size of view state??

893