top button
Flag Notify
    Connect to us
      Site Registration

Post under tag sql server
Site Registration

Most answered questions under tag sql server

0 votes
1 answer
What is an execution plan? When would you use it? How would you view the execution plan?
posted Nov 27, 2014 by Vinitha
  • sql server
0 votes
1 answer
What are sp_configure commands and set commands?
posted Nov 27, 2014 by Vinitha
  • sql server
+4 votes
1 answer
Which are new data types introduced in SQL SERVER 2008?
posted Nov 26, 2014 by Manikandan J
  • sql server
0 votes
1 answer
What command do we use to rename a db, a table and a column?
posted Nov 26, 2014 by Vinitha
  • sql server
0 votes
1 answer
Name 3 ways to get an accurate count of the number of records in a table?
posted Nov 26, 2014 by Vinitha
  • sql server
0 votes
1 answer
What are the authentication modes in SQL Server? How can it be changed?
posted Nov 26, 2014 by Roshan
  • sql server
0 votes
1 answer
What are the properties and different Types of Sub-Queries?
posted Nov 26, 2014 by Roshan
  • sql server
0 votes
1 answer
What are different types of Collation Sensitivity?
posted Nov 26, 2014 by Roshan
  • sql server
0 votes
1 answer
What is sub-query? Explain properties of sub-query?
posted Nov 26, 2014 by Balu
  • sql server
0 votes
1 answer
What is Filestream?
posted Nov 25, 2014 by Balu
  • sql server
0 votes
1 answer
What is Data Compression in the context of SQL Server?
posted Nov 25, 2014 by Roshan
  • sql server
0 votes
1 answer
How would you handle error in SQL SERVER 2008?
posted Nov 25, 2014 by Vinitha
  • sql server
0 votes
1 answer
How can we rewrite sub-queries into simple select statements or with joins?
posted Nov 25, 2014 by Vinitha
  • sql server
+1 vote
1 answer
How do we create trigger on system tables? What can be the reasons to create trigger on system tables?
posted Nov 22, 2014 by Vrije Mani Upadhyay
  • sql server
+1 vote
1 answer
What is difference between stored procedure and user defined function?
posted Nov 22, 2014 by Roshan
  • sql server
+1 vote
1 answer
What are different types of replication in SQL Server?
posted Nov 22, 2014 by Vinitha
  • sql server
+1 vote
1 answer
What is the difference between system objects and user objects?
posted Nov 21, 2014 by Vinitha
  • sql server
+3 votes
1 answer
Difference between Left Join and Left outer join?
posted Nov 20, 2014 by Muskan
  • sql server
+1 vote
1 answer
What are the different types of BACKUPs available in SQL Server 2005?
posted Nov 18, 2014 by Roshan
  • sql server
+4 votes
1 answer
remove decimal points from a column value.
posted Nov 14, 2014 by Khusboo
  • sql server
+2 votes
1 answer
What is the difference between SET and SELECT?
posted Nov 14, 2014 by Balu
  • sql server
+1 vote
1 answer
What is the difference between a DDL trigger and a DML trigger?
posted Nov 13, 2014 by Roshan
  • sql server
+4 votes
1 answer
add a Default Value Constraint
posted Nov 3, 2014 by Muskan
  • sql
  • sql server
+4 votes
1 answer
How to check if a Constraint exists in Sql server?
posted Nov 3, 2014 by Khusboo
  • sql server
  • sql
+2 votes
1 answer
What are the steps you will take, if you are tasked with securing an SQL Server?
posted Oct 29, 2014 by Vidhya Sagar
  • sql server
+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
  • sql server
+1 vote
1 answer
What changed between the previous version of SQL Server and the current version?
posted Oct 29, 2014 by Vidhya Sagar
  • sql server
+2 votes
1 answer
What are the new features introduced in SQL Server 2000 ?
posted Oct 29, 2014 by Vidhya Sagar
  • sql server
+2 votes
1 answer
Explain the storage models of OLAP?
posted Oct 29, 2014 by Vidhya Sagar
  • sql server
+2 votes
1 answer
What is lock escalation?
posted Oct 29, 2014 by Vidhya Sagar
  • sql server
  • oracle
  • sql
+2 votes
1 answer
Explain the architecture of SQL Server?
posted Oct 29, 2014 by Vidhya Sagar
  • sql server
+2 votes
1 answer
When do you use UPDATE_STATISTICS command?
posted Sep 26, 2014 by Deepak Negi
  • sql server
0 votes
1 answer
What are the types of SQL GROUP BY Clause?
posted Sep 14, 2014 by Nimish
  • sql
  • sql server
+2 votes
1 answer
What is Change Data Capture (CDC) in SQL Server 2008?
posted Sep 10, 2014 by Muskan
  • sql server
  • sql
  • vb.net
+2 votes
1 answer
What is BCP? When is it Used?
posted Sep 10, 2014 by Merry
  • sql server
  • sql
+2 votes
1 answer
What is the STUFF Function and How it differ from the REPLACE Function?
posted Sep 10, 2014 by Khusboo
  • sql server
+1 vote
1 answer
How to get @@ERROR and @@ROWCOUNT at the Same Time?
posted Sep 4, 2014 by Khusboo
  • sql server
+2 votes
1 answer
Truncate decimal value but not round off the value in SQL Server?
posted Sep 2, 2014 by Muskan
  • sql server
+1 vote
1 answer
What is SQL Server Agent?
posted Aug 24, 2014 by Deepak Negi
  • sql server
+2 votes
1 answer
What are indexed views?
posted Aug 22, 2014 by Merry
  • sql server
  • sql
+2 votes
1 answer
Recursice Stored Procedure!
posted Aug 22, 2014 by Muskan
  • sql server
  • mysql
+2 votes
1 answer
What security features are available for stored procedure?
posted Aug 22, 2014 by Khusboo
  • sql server
+2 votes
1 answer
What is Scope identity and When is it used?
posted Aug 8, 2014 by Muskan
  • sql server
  • sql
0 votes
1 answer
Dynamic expressions implementation
posted Aug 5, 2014 by Sachin
  • informatica
  • sql server
0 votes
1 answer
One PHP Login Form for Different databases?
posted Jul 7, 2014 by Deepak Negi
  • php
  • sql server
+2 votes
1 answer
CTE vs Temp Tables
posted Jul 5, 2014 by Khusboo
  • sql
  • sql server
+2 votes
1 answer
Please explain CTE (Common Table Expressions) with a simple example?
posted Jun 23, 2014 by Muskan
  • sql server
  • sql
+4 votes
1 answer
How to list all foreign keys referencing in a given table?
posted May 28, 2014 by Merry
  • sql server
+4 votes
1 answer
SQL: How to SELECT * INTO [temp table] FROM [stored procedure]
posted May 28, 2014 by Khusboo
  • sql server
  • sql
+4 votes
1 answer
What is the use of sp_xml_preparedocument?
posted May 12, 2014 by Merry
  • sql server
Page:
...