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 136866

About types of indexes in SQL server ?

 2 5616

Difference between writing SQL query and stored procedure ?

 15 66177

About DTS usage ?

 2 5882

How do you optimize Sql queries ?

 1490




Rate yourself in .NET and SQL ?

 1 6595

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

 15 18436

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

 1216

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

 10 12979

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 9297

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 5582

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 2521

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 3372

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 3832

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 6096

Post New Cognizant SQL Server Interview Questions




Cognizant SQL Server Interview Questions


Un-Answered Questions

Is coding essential for Blue Prism?

1

What is use of JavaScript and jquery?

187

WHAT IS THE DIFFERENE IN ACTION OF MCB,MCCB,RCCB

1492

How to know which medium works best?

1324

Can you enlist some commonly used network commands?

165




Which is latest technology in java?

107

Explain how does hydraulic clutches work?

136

working principle of direct digital controllers(DDC Panel)

2905

what is the implemention project in sap?

1330

My sql statement select avg(salary) from emp yields inaccurate results. Why?

179

what is meant by 3rd hormonics ?

927

What are the core interfaces are of hibernate framework?

1

Can we create dynamic website in wordpress?

15

When a campaign is showing as pending within adwords, what is it?

1

How many digits are in an integer?

113