Oh my, that is some frighteningly bad advice.

Backup log with truncate only? Shrink data files? Both with no mention of the downsides and consequences of them?

Then what was the point of posting it?

its just a matter of concept...

Kishore.P (4/17/2009)

---

krishrana17 (4/17/2009)

---

Hi,

Thanks for replying...

Here is the Error message that i got when i m changing the identity column to "Yes" and save the changes.

Saving changes is not permitted....

Not in 2005. In SQL 2008 there's an easy way...

That's not a bug. It's a safety measure added to SQL 2008's management studio to indicate that the change that you've requested to the table requires that the table be...

mithun.gite (4/17/2009)

---

Actually I have been asked to Optimize the query and do the performance tunning to the query.

select * from emp where dept_no in(10,20,30)

As in this query only optimization we...

Consider a mirroring or clustering setup where there's an active server and a failover server that's offline. Split brain refers to a scenario where, for whatever reason, the communication link...

Did you look at the Books Online pages that I suggested? The page "Reorganizing and Rebuilding Indexes" has a couple paragraphs exactly that, which to use when.

Here's the online link...

What does this return?

exec sp_configure 'default trace enabled'

I don't think that the default trace keeps record of deletes. It doesn't have all that many events in it.

If you didn't have...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic699124-8-1.aspx

The RID (Row Identifier). FileID, PageID, Slot index

On a 2005 server you shouldn't be using either. They're both deprecated.

Look up ALTER INDEX in books online, specifically the sections REBUILD (the replacement for DBCC DBREINDEX) and REORGANISE (the...

Well, if you look at that little note from books Online, it indicates that sp_updatestats will only update statistics that are 'out of date', based on the value of rowmodcnt,...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: [urlhttp://www.sqlservercentral.com/Forums/Topic699152-360-1.aspx][/url]

Depends. Was each of those inserts in it's own transaction or was there a single begin transaction at the beginning and a commit at the end?