Skip to main content

All Questions

Filter by
Sorted by
Tagged with
0 votes
2 answers
522 views

How to find Sum of dynamically generated time attribute in sql server 2012

I have a table with two columns (TASKID and Dateadded). I am trying to find difference between timings and would like to calculate the sum of the diff (time) attribute. select taskid,dateAdded,CAST((...
Nalo Nenu's user avatar
6 votes
1 answer
1k views

What Other Information Is Stored in The Page Header

A SQL Server database page is defined as to be 8192 bytes in size. There is some header information which is said to be 96 bytes in size. And if you have ever tried to create a table with more than ...
John K. N.'s user avatar
  • 18.3k