Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 149588

About types of indexes in SQL server ?

2 6209

Difference between writing SQL query and stored procedure ?

15 69555

About DTS usage ?

2 6564

How do you optimize Sql queries ?

1721

Rate yourself in .NET and SQL ?

1 7533

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

15 20633

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

1460

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

10 14420

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 11059

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 6154

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 2965

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 3832

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 4273

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 6726

Post New Cognizant SQL Server Interview Questions


Cognizant SQL Server Interview Questions


Un-Answered Questions

What is partner function & configuration

931


What changes does a control need to run in an MFC 4.2b container?

1672


Can both account-based and costing based profitability analysis be configured at the same time?

424


How to Reprocess Idocs in SAP?

427


Why is objective c used?

1






How can calculate the rating of a servo stabilizer for given a specific load

2879


What are the different types of 'Fixed Deposits'?

524


Where do you see yourself in next 3 to 5 years from now?

555


i'm testing the webpage with QTP, in this wabpage i have to choose the CV from the window, but QTP can't recognize the object, so i used the Low LEvel Recording, but every time i run the test, QTP go to halt when it gets to the Recorded part, any solution for that?( except puting delay in the script and manuall selecting, because i've did that)

1331


What is a cookie in java?

346


How many main () function we can have in a project?

429


Name and describe few sas character functions that are used for data cleaning in brief.

449


How to disiegn DCV circuit ?

1991


Why lazy evaluation is good in spark?

123


Hey Guyz I m Pakhi.im a b.tech 8th sem student.i want to make my career in human resource management.a project has submitted in college in the end of this sem. should i take my training in language or should i find the hr job? can i get a job in human resource managements after b.tech or firstly i have to do MBA. pls tell me i m very confused....... pls... can also tell me in this e-mail id bandana.thakur14at@gmail.com (she is my sister)

1719