Most voted questions under tag sql server

+10 votes

2 answers

How to export data from Sql Server to MS Excel?

posted Feb 6, 2014 by Asmita Agrawal

+9 votes

1 answer

Search for a string in SQL

posted Feb 9, 2014 by Neeraj Pandey

+7 votes

1 answer

What is the use of Merge in SQl Server 2008 ?

posted Feb 5, 2014 by Neeraj Pandey

+7 votes

1 answer

What is the use of sp_exectesql in sql server

posted Dec 19, 2013 by Neeraj Pandey

+6 votes

1 answer

How to change multiple column datatype in SQL Server single query.

posted Apr 1, 2015 by Khusboo

+6 votes

1 answer

Select 2nd Highest salary from employee table

posted Nov 28, 2014 by Manikandan J

+6 votes

1 answer

How do I get back some deleted records?

posted Feb 19, 2014 by Asmita Agrawal

+6 votes

1 answer

What is exact_abort in SQL Server?

posted Jan 4, 2014 by Atul Mishra

+6 votes

1 answer

How will you find out 7th highest salary in a table?

posted Dec 19, 2013 by Neeraj Pandey

+6 votes

2 answers

What is OpenQuery in SQl server

posted Dec 19, 2013 by Neeraj Pandey

+6 votes

1 answer

What is maxdop in sql server

posted Nov 19, 2013 by Shweta Gupta

+6 votes

1 answer

How to return XML in SQL Server?

posted Nov 18, 2013 by Atul Mishra

+6 votes

1 answer

SQL Server: Difference Between Implict Transaction And Explict Transaction

posted Nov 18, 2013 by Atul Mishra

+6 votes

2 answers

Temp tables in SQL server?

posted Nov 18, 2013 by Atul Mishra

+5 votes

1 answer

What are various ways to enhance the SSRS report? Explain.

posted Oct 29, 2015 by Shivaranjini

+5 votes

1 answer

What is the meaning of Redo Log file mirroring in SQL?

posted Oct 19, 2015 by Shivaranjini

+5 votes

1 answer

How to create a CSV file of any table by sql query in sql server?

posted Aug 3, 2015 by Mohammed Hussain

+5 votes

1 answer

What are the advantages and disadvantages of SqlServer Session mode?

posted Dec 11, 2014 by Manikandan J

+5 votes

1 answer

User Defined Data Types in SQL Server?

posted Mar 27, 2014 by Muskan

+5 votes

1 answer

Drill Down Reports in SSRS.

posted Feb 17, 2014 by Asmita Agrawal

+5 votes

2 answers

SQL Server: What does the NOLOCK query hint do?

posted Nov 18, 2013 by Atul Mishra

+5 votes

1 answer

What are DMVs in context of SQL Server?

posted Nov 18, 2013 by Atul Mishra

+4 votes

1 answer

How do you reference an embedded function in a report expression?

posted Nov 3, 2015 by Shivaranjini

+4 votes

1 answer

What are the differences between lost updates and uncommitted dependencies?

posted Oct 23, 2015 by Vrije Mani Upadhyay

+4 votes

1 answer

Explain various data region available in SSRS with their use?

posted Oct 19, 2015 by Shivaranjini

+4 votes

1 answer

What are the restrictions while creating batches in SQL Server?

posted Oct 19, 2015 by Shivaranjini

+4 votes

0 answers

Variations for CASE in SELECTs (pros/cons)

posted Jun 30, 2015 by Manikandan J

+4 votes

1 answer

What would you do to optimize slow-running queries?

posted Jun 30, 2015 by Manikandan J

+4 votes

2 answers

How sql server know when a query has to compile or not?

posted Jun 23, 2015 by Mohammed Hussain

+4 votes

1 answer

When should we use EXISTS, and when should we use IN?

posted Jun 23, 2015 by Manikandan J

+4 votes

1 answer

Please let me know the query to update this

posted Jun 18, 2015 by Shivaranjini

+4 votes

1 answer

Sql server: Check string comparison is case sensitive or not?

posted Jun 8, 2015 by Mohammed Hussain

+4 votes

1 answer

How to fetch values from xml into table in sql

posted Mar 27, 2015 by Muskan

+4 votes

1 answer

What are the most important database performance metrics, and how do you monitor them?

posted Feb 12, 2015 by Merry

+4 votes

1 answer

What are the different implementations of LINQ?

posted Dec 24, 2014 by Muskan

+4 votes

1 answer

Select TOP 2 salary from employee table

posted Nov 28, 2014 by Manikandan J

+4 votes

1 answer

What is log shipping?

posted Nov 28, 2014 by Manikandan J

+4 votes

0 answers

Is there any way to auto align big queries in Sql server?

posted Nov 26, 2014 by Khusboo

+4 votes

1 answer

Which are new data types introduced in SQL SERVER 2008?

posted Nov 26, 2014 by Manikandan J

+4 votes

1 answer

remove decimal points from a column value.

posted Nov 14, 2014 by Khusboo

+4 votes

1 answer

add a Default Value Constraint

posted Nov 3, 2014 by Muskan

+4 votes

1 answer

How to check if a Constraint exists in Sql server?

posted Nov 3, 2014 by Khusboo

+4 votes

1 answer

How to list all foreign keys referencing in a given table?

posted May 28, 2014 by Merry

+4 votes

1 answer

SQL: How to SELECT * INTO [temp table] FROM [stored procedure]

posted May 28, 2014 by Khusboo

+4 votes

1 answer

What is the use of sp_xml_preparedocument?

posted May 12, 2014 by Merry

+4 votes

1 answer

how to check if table exist and if it doesnt exist create table in sql server 2008

posted May 9, 2014 by Muskan

+4 votes

0 answers

Generic Method to Create and Execute Parameterized SQL Query in .NET 4.0

posted May 8, 2014 by Muskan

+4 votes

0 answers

How can I save image in SQL SERVER by VB.NET?

posted May 6, 2014 by Khusboo

+4 votes

0 answers

What are wild cards used in database for Pattern Matching ?

posted May 2, 2014 by Khusboo

+4 votes

1 answer

Debug a Stored Procedure..!!

posted Apr 1, 2014 by Khusboo