Answer / arunyadav007

The fundamental unit of data storage in SQL Server in the
page. The disk space allocated to a data file (.mdf
or, .ndf) in a database is logically divided into pages
numbered form “0” to ‘n’. Disk I/O operation are performed
at page level.
In SQL server, the page is 8 kb. This means SQL Server
database have 128 pages per MB. Each page begins with a 96
byte header. That is used to store system information about
the page.
Page types used in the data files of the SQL Server
database.
1.) Data
2.) Index
3.) Text image
4.) Global allocation map, shared global allocation map
5.) Page free space.
6.) Index allocation map
7.) Bulk changed map
8.) Differential changed map
** Maximum amount of data and overload that is contained in
single row on a page is 8060 bytes ()8Kb.

How do I uninstall sql server 2014?

0 Answers  

---

What does executeupdate return?

0 Answers  

---

What is MSDE?

2 Answers  

---

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---

What is precedence constraint?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

What is key set driven?

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

Explain cdc and sql injection?

0 Answers  

---

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---