Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic780445-148-1.aspx

Tell your manager he's an idiot.

Yes, it's possible, it is however in no way a good idea. CLR is an alternative to T-SQL for procedures, not a replacement. It's good...

Sorry, I left a column and the join condition out. They should be joined on ParentID as that's the foreign key between the tables.

This should work better

SELECT Parent.LastName, Parent.FirstName, FirstChild.LastName,...

And take a full backup...

Please take a look at the article I posted for a way to save the plan in Excel. The text plans are really hard to read.

The table definition is not...

Then your server is SQL 2000. There's an explaination of how to save an exec plan on SQL 2000 in this article - http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Yes

It only effects bulk type transactions...

Highly unlikely. All it's doing is on one single...

There's already duplicate users in the system. We've got at least one case where two people have the same username. Something has to be don e about those and I...

wjones21 (8/31/2009)

---

My company is obviously concerned about the 10 hour+ exposure without a backup that an online reindexing process will lead to with the DB in SIMPLE recovery mode. The...

jeremym (8/31/2009)

---

From what I have read in the past when you did the full backups this would truncate the LDF files. This isn't the case in SQL 2008....

Are you using any 3rd part monitoring tools?

DBCC TRACEON is usually used in conjunction with something like DBCC PAge, to return output to the client.

21 seconds is very long for a single query. Are you willing to post execution plan, query and table and index definitions and let us take a look at it?

You can, but....

Yes

3. ...not worry about it filling up my transaction log and...

You'll see it as latch waits, typically on either resource 2:1:2 or 2:1:3, more commonly the...