Answer Posted / siddharth

xp means Extended Procedure . These procedrue are made from
dlls written in c++.

Example- XP_cmdshell is a extended procedure to run all dos
commands in sql server.

What part does database design plays a role in performance of an sql server-based application?

943

---

How can we rewrite sub-queries into simple select statements or with joins?

941

---

What is set nocount on?

903

---

Write a SQL queries on Self Join and Inner Join.

1000

---

How to access the deleted record of an event?

989

---

What is 2nf normalization?

980

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2893

---

What is the usage of sign function?

1054

---

How to delete existing triggers using "drop trigger"?

1011

---

How to disable a login name in ms sql server?

1078

---

What is row_number () and partition by in sql server?

1027

---

explain the storage models of olap? : Sql server database administration

905

---

what is difference between NULL and ISNULL in SQL Server 2008?

977

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

996

---

Write the syntax for stuff function in an sql server?

993

---