Most voted questions under tag sql server

+4 votes

0 answers

SQL Server multiple tables to Excel multiple sheets

posted Mar 28, 2014 by Merry

+4 votes

1 answer

How can we alter a huge table in SQL

posted Feb 27, 2014 by Neeraj Pandey

+4 votes

1 answer

What are the ways to find what code is running for any spid?

posted Feb 21, 2014 by Prachi Agarwal

+4 votes

1 answer

How to Start Service Using Powershell Commands?

posted Feb 21, 2014 by Prachi Agarwal

+4 votes

1 answer

Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?

posted Feb 21, 2014 by Neeraj Pandey

+4 votes

0 answers

When we get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

posted Feb 21, 2014 by Neeraj Pandey

+4 votes

1 answer

What does it mean to have QUOTED_IDENTIFIER ON?

posted Feb 20, 2014 by Muskan

+4 votes

1 answer

What is SQL Profiler?

posted Feb 20, 2014 by Khusboo

+4 votes

1 answer

How can we get comma separated values from a column in a table

posted Feb 18, 2014 by Neeraj Pandey

+4 votes

1 answer

SQLSERVER: Column with distinct value but mulitple NULL value?

posted Feb 18, 2014 by Atul Mishra

+4 votes

1 answer

What is the alternative of shrinking the log file if data base size is getting larger

posted Feb 14, 2014 by Neeraj Pandey

+4 votes

1 answer

How to create a view and a stored procedure using "CREATE VIEW/PROCEDURE" statements ?

posted Feb 2, 2014 by Mona Sharma

+4 votes

1 answer

RaiseError function in SQL Server, parameter explanation?

posted Jan 4, 2014 by Atul Mishra

+4 votes

1 answer

How can we get alternative rows from a table in sql server

posted Dec 24, 2013 by Neeraj Pandey

+4 votes

2 answers

SQL Server: How can we remove duplicate rows from a table

posted Dec 6, 2013 by Neeraj Pandey

+4 votes

1 answer

What is the default port number for SQL Server?

posted Nov 18, 2013 by Atul Mishra

+3 votes

1 answer

In SSRS report can we edit the .rdl code associated with a linked report?

posted Nov 3, 2015 by Shivaranjini

+3 votes

1 answer

What are the three SSRS command-line utilities and their primary functions?

posted Nov 3, 2015 by Shivaranjini

+3 votes

1 answer

What is the significance of NULL value and why should we avoid permitting null values?

posted Oct 23, 2015 by Vrije Mani Upadhyay

+3 votes

1 answer

What is new in lock escalation in SQL Server 2008?

posted Oct 16, 2015 by Shivaranjini

+3 votes

1 answer

What is the difference between update lock and exclusive lock in SQL Server?

posted Oct 16, 2015 by Shivaranjini

+3 votes

1 answer

What are Catalog view in SQL server ?

posted Oct 16, 2015 by Shivaranjini

+3 votes

1 answer

How would you handle NULL problems?

posted Jun 30, 2015 by Manikandan J

+3 votes

1 answer

What is COALESCE?

posted Jun 30, 2015 by Manikandan J

+3 votes

1 answer

SQL update from one Table to another based on a ID match

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

SQL Server - Update column from data in the same table

posted Jun 19, 2015 by Manikandan J

+3 votes

1 answer

Any body know the query about this senario

posted Jun 18, 2015 by Shivaranjini

+3 votes

1 answer

How to create cursor in sql server 2008?

posted Jun 2, 2015 by Shivaranjini

+3 votes

1 answer

how to insert multiple records in a single query?

posted May 15, 2015 by Muskan

+3 votes

1 answer

What is open query in sql server?

posted Apr 8, 2015 by Muskan

+3 votes

1 answer

What is mixed mode authentication in sql server???

posted Mar 11, 2015 by Muskan

+3 votes

1 answer

What is EJB in Java? What are the different types of EJB?

posted Feb 1, 2015 by Amit Kumar Pandey

+3 votes

0 answers

Is there a way to make the Sql Server FullText engine to stop recognizing numbers as numbers?

posted Jan 2, 2015 by Vrije Mani Upadhyay

+3 votes

1 answer

select data from multiple rows in a single columnsql

posted Dec 5, 2014 by Merry

+3 votes

1 answer

How to rebuild Master Database?

posted Nov 28, 2014 by Manikandan J

+3 votes

1 answer

Difference between Left Join and Left outer join?

posted Nov 20, 2014 by Muskan

+3 votes

1 answer

What are the steps you will take to improve performance of a poor performing query?

posted Oct 29, 2014 by Vidhya Sagar

+3 votes

0 answers

How to raise exception in a Stored Procedure?

posted Aug 20, 2014 by Khusboo

+3 votes

0 answers

How to convert c # inline queries into stored procedure written in transact sql?

posted May 8, 2014 by Khusboo

+3 votes

1 answer

What is the difference between CAST and CONVERT in sql server?

posted Apr 28, 2014 by Muskan

+3 votes

1 answer

How to catch check constraint violation error in Database.

posted Apr 21, 2014 by Merry

+3 votes

1 answer

What is the difference between sub & correlated subquery?

posted Apr 18, 2014 by Merry

+3 votes

0 answers

Error - SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM

posted Apr 18, 2014 by Merry

+3 votes

1 answer

What are the Dynamic management views in sql server?

posted Apr 18, 2014 by Neeraj Pandey

+3 votes

1 answer

What is difference between rebuild and reorganize the indexes in SQL Server?

posted Apr 3, 2014 by Neeraj Pandey

+3 votes

1 answer

What is the meaning of lock escalation and why/how to stop this?

posted Mar 31, 2014 by Prachi Agarwal

+3 votes

0 answers

WHICH ONE WILL BE FASTER IN SQL SERVER: INSERTING ONE MILLION ROWS OF DATA, OR UPDATING ONE MILLION ROWS OF DATA?

posted Mar 31, 2014 by Prachi Agarwal

+3 votes

1 answer

I want to append output data from a query into an existing file, which command prompt tool will help me?

posted Mar 29, 2014 by Neeraj Pandey

+3 votes

1 answer

What does sp_validname do in SQL Server ?

posted Mar 29, 2014 by Neeraj Pandey

+3 votes

1 answer

Replication Administration sql

posted Mar 26, 2014 by Muskan