I would if I remembered it. It might have been a conversation I had at SQL Saturday DC. I just don't recall, sorry.

Not a problem. I just like to be clear when I'm posting for one of our products.

It really is one I used to use all the time for the databases...

Steve Thompson-454462 (12/13/2013)

---

joe.eager (12/13/2013)

---

I agree, on doing small slices of the data model, I guess I'm just worried about the re-factoring chunks near the end. But as was mentioned...

Great opportunity for a third party product. Red Gate SQL Doc[/url] does this extremely well.

And, disclaimer, I work for Red Gate.

In addition to what Lowell said, how about identifying where the slow down is from the ASP side of things. I'd suggest looking at a tool like this[/url] to identify...

Hmmmm... Well, it's almost a materialized view, but that's a view with a clustered index which makes it effectively a table. This is different. I guess I'd go with denormalized...

Yep. Almost definitely disk space.

So what you're looking for is a SELECT statement. You'll need to especially focus on the column list and the WHERE clause. Read all about it here. If you are...

I'm with Elliot. I've done lots of programming in and around XML on SQL Server. It's functional. But it's not terribly fast. If you're just talking, writing and reading this...

I'm not an Oracle person, so my understanding here may be grossly inadequate, but the short answer is No.

The longer answer is, I think, that you're doing lots and lots...

It's pretty standard to not have domain admin and sometimes not even machine admin. But, you have to have enough privileges to set up the things you need to set...

But if you're hitting slow performance on inserts/updates, adding a log table to the whole thing is going to slow it down further.

I'd suggest capturing statement level events with extended...

To understand why a SELECT statement is slow, you need to look at the execution plan to understand how the optimizer is resolving the query. Also, you need to look...

ananda.murugesan (12/12/2013)

---

I want to know if an issue...

I am not aware of a way to reset those counters, no. Sorry.