jerome.morris (12/6/2012)

---

Hi guys I am trying to update my Database column using the below, if the column is not present it get created fine, but wont set all the entries...

What's hard about a...

Try sys.dm_db_partition_stats for table and index.

Column space usage isn't stored. Best you'll be able to do is average size of the column * number of rows.

Huh?

The SQL error log, C:\Program Files (x86)\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log\ERRORLOG, open it in notepad and paste the last few lines here

RAM per user?

As for SQL's memory, http://www.sqlskills.com/blogs/jonathan/post/how-much-memory-does-my-sql-server-actually-need.aspx

Faster in this case does not mean noticably or measurably faster. Maybe a few microseconds for a simple comparison like that. Joins show more of an effect, but you still...

If you're not using a transaction, then SQL is in auto-commit mode meaning once a statement completes it automatically commits and can't then be rolled back.

No.

http://www.sqlskills.com/blogs/paul/post/Misconceptions-around-the-log-and-log-backups-how-to-convince-yourself.aspx

Log shipping does not remove the...

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Start with chapter 1.

What's the last few messages in the SQL error log?

Has the primary been restored from a backup?

sanket kokane (12/6/2012)

---

Yes...

Ravi-156610 (12/6/2012)

---

We have Log Shipping setup on SQL 2008 instances and everything was running fine until the primary database was accidentally taken offline. We bought the DB online but noticed...

sqlfriends (12/5/2012)

---

So if a database is set to read only , and by just querying the database, it won't create any log transactions, so no affect on log file, is...