top button
Flag Notify
    Connect to us
      Site Registration

Post under tag sql server
Site Registration

Recent posts under tag sql server

0 votes
1 answer
Where SQL server user names and passwords are stored in SQL server?
posted Nov 27, 2014 by Vinitha
  • 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
0 answers
Is there any way to auto align big queries in Sql server?
posted Nov 26, 2014 by Khusboo
  • 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
2 answers
What is LINQ?
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
2 answers
What are Magic tables in SQL Server?
posted Nov 22, 2014 by Vrije Mani Upadhyay
  • 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
2 answers
What are the basic functions for master, msdb, model, tempdb databases?
posted Nov 22, 2014 by Vinitha
  • sql server
+1 vote
2 answers
Explain different types of Locks in SQL Server?
posted Nov 22, 2014 by Balu
  • sql server
+1 vote
2 answers
What are the properties of the Relational tables?
posted Nov 22, 2014 by Balu
  • 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
2 answers
How many types of triggers are there?
posted Nov 18, 2014 by Vinitha
  • 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
0 votes
2 answers
What are constraints? Explain different types of constraints?
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
+2 votes
2 answers
What are the difference between primary keys and foreign keys?
posted Nov 14, 2014 by Balu
  • sql server
+2 votes
2 answers
What is the difference between a local and a global variable?
posted Nov 13, 2014 by Roshan
  • 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
+1 vote
2 answers
How to create recursive query in SQL Server?
posted Sep 26, 2014 by Rahul Singh
  • 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
0 answers
How can I backup SQL Database from my VB.Net Windows Application?
posted Sep 12, 2014 by Tapesh Kulkarni
  • vb.net
  • sql server
  • backup
+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
Page:
...