post the sample data with expected output

post the definition of all related queries along with view

it can, but for better...

yogesh.bhor (1/14/2013)

---

The concurrent snapshot for publication 'Publication_name' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation...

yes, you can try Checkdb and at a side , i will suggest again go through the link which i posted above

steve 50602 (1/13/2013)

---

If I wanted the sort order changeable via the website, then I would definitely use something like CHARINDEX, as it seems a pretty flexible solution. I'd probably just...

anthony.green (1/14/2013)

---

There is remote query timeout setting in SQL but that only takes affect if you are quering a remote server using something like linked servers, there is nothing in...

I dont think disk shortage could lead to torn page, it generally happens because of system/disk outage.

see the link http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/

+ 1

anthony.green (1/14/2013)

---

As for the time out, that is set at the connection string, SQL doesnt have a time out setting for local queries, they run until they are told to...

Vedran Kesegic (1/11/2013)

---

I hope it is not your regular procedure, because updating primary key which is by default also a clustered index key, is a very bad idea because of...

A side question , can...

i think "insert into select " provide better readabilty when we use this approach in "long time used queries/stored proc". we can easily see what are the columns and what...

Another thing which we can try here is

----instead of

WHERE StatementID IN (SELECT StatementID FROM MyDB_ARCHIVE.dbo.StatementHeader)

-----test it

WHERE exists (SELECT 1 FROM MyDB_ARCHIVE.dbo.StatementHeader A where A.StatementID =...

for indentity columns , check the column is_identity in sys.columns table , its a bit wise...