what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

What is an extended Stored Procedure?

1 Answers  

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

What are page splits? : SQL Server Architecture

0 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

What are the four main query statements?

7 Answers   Wipro,

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What is sql server profiler trace data file?

0 Answers  

---