Answer / Harpal Singh

To find out which stored procedures are recompiling in SQL Server, you can use the sys.dm_exec_query_stats dynamic management view or the sp_BlitzCache stored procedure. These tools provide information about executed queries and their compilations.

What do you understand by physical_only option in dbcc checkdb?

1 Answers  

---

What are the different subsets of sql?

0 Answers  

---

Does a sql server 2005 select statement require a from?

1 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

What stored procedure would you use to view lock information?

1 Answers  

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is sql server programming?

1 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

1 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1 Answers  

---

Write a SQL queries on Self Join and Inner Join.

1 Answers   Aspiring Minds,

---

How do you start single user mode in clustered installations?

1 Answers  

---