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 143400

About types of indexes in SQL server ?

2 5934

Difference between writing SQL query and stored procedure ?

15 67803

About DTS usage ?

2 6207

How do you optimize Sql queries ?

1614





Rate yourself in .NET and SQL ?

1 7122

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

15 19589

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

1349

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

10 13668

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 10144

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 5866

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 2729

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 3615

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 4042

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 6369

Post New Cognizant SQL Server Interview Questions




Cognizant SQL Server Interview Questions


Un-Answered Questions

What is the purpose of a model?

229


What is JMX?

92


How to install the adapters in different opreating systems ?

1687


How to detect the server version?

276


Explain the concept of cassandra data model?

46






Do you know what is the use of volatile keyword?

257


what will happen if one could not properly follow the spacing of slab reinforcement bar?

1232


Is array value type in c#?

256


Why do we need HTML 5 server-sent events?

258


What are segregation and bleeding?

372


Which is api based tool supported by salesforce and what are its advantages? : salesforce Data Management

35


Clarify what a task tracker is in hadoop?

87


How many default tab strips are there? How to insert more tabs in it?

291


How many threads can java run?

261


What snap-in administrative tools are available for active directory?

44