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?

Ignore it.

Error 208 is Object not found. It's not uncommon for profiler to show 'false' errors due to internal deferred name resolution.

http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2004/12/16/40.aspx

Update them. If you delete the statistics you're forcing SQL to recreate them when it thinks they're necessary. Doing so could adversely affect an important query.

Use UPDATE STATISTICS rather than...

Since this is SQL 2005, rather use sys.objects and sys.sql_modules

I know I've said that UPDATEUSAGE isn't required (in the discussion of the corruption article), but I don't recall ever saying that stats updates are never required.

If anyone knows...