Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Cognizant SQL Server Interview Questions
Questions Answers Views Company eMail

how to find nth highest salary

103 156921

About types of indexes in SQL server ?

2 6646

Difference between writing SQL query and stored procedure ?

15 71417

About DTS usage ?

2 7018

How do you optimize Sql queries ?

1852

Rate yourself in .NET and SQL ?

1 7879

how to retrive only second row from table in sql server 2000?

15 22044

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

1597

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 15434

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 12283

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 6557

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 3201

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO

1 4124

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 4567

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 7197

Post New Cognizant SQL Server Interview Questions


Cognizant SQL Server Interview Questions


Un-Answered Questions

How do you summarize data in excel?

278


What is document store db?

50


Is microsoft visual studio for free?

382


What is the advantage of using MVC pattern?

5


Explain the change in outlook client connection behaviour when compared with exchange 2010?

544






14 year old woman requests the combined oral contraceptive pill for contraception. Please see her and discuss her management?

1612


if you get chance to become a manager, how will you manage your self?

1971


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5489


What would be your sourcing strategy to buy low value items?

3425


Do you know what is the function of managedconnection.addconnectioneventlistener() in web logic server?

479


What are the benefits of a jar file?

455


What is the difference between volumetric solutions and test solutions

2518


How do you create a new file in ubuntu?

381


What is the name of a file?

461


How is the scope of aggregation defined?

5