PaulB-TheOneAndOnly (5/30/2011)

---

For starters, if you come to my desk with a 1:1 relationship better for you to have very, really strong arguments about why those two tables are not just...

Grant Fritchey (5/29/2011)

---

You're right, this can be practically a religious war.

In general, I've found that identity works well, but can be abused. In the situation you're describing for example, I'd...

In the past I've handled this in BIDS by having two separate RDL's displayed full page as subreports in a single parent RDL.

So it's just two boxes in the...

Thank you for the responses.

The idea of Set Based first, Efficient second seems to be along my way of thinking, I just want to make sure I recognize where...

One of my questions about managing the same query against multiple servers wasn't referring to live queries, but automated.

For ex:

I run a query to see if db/log is running low...

Well I'm a DBA first, C# developer second, web developer third, so I fully agree with a preference toward a centralized CRUD for immediate performance and centralization of logic.

My Director...

Actually is there a way to verify that the computer is using all 128GB?

If I set Max Server Memory to 121GB and it can only access 64GB, it'll still...

Pretty much a dedicated server.

Only SSMS and RDM have been used aside from admin tools like perfmon and those only get used on a rare occasion.

I'll take a look at...

I figured since it managed it's own memory. Thank you.

Total Server Memory (KB): 50177792. Unchanging.

This is the value I was seeing under Paging File under Task Manager.

Well it's 52.2GB...

Steve Wright-233748 (7/27/2010)

---

Hi,

I'm with SQL Sentry and noticed your post. SQL Sentry provides a complete graphical representation of all deadlocks with a grid display listing all nodes organized by...

I'm having trouble getting this from the error log. It seems to be a wall of text, we were having 20+ per hour and each is multiple lines.

Here is...

I'm not sure how to obtain such a graph. In SQL Response the data from the graph is displayed, some of it as a graphical representation as well.

But we found...

These inserts are generated off of the after update/insert trigger on a table. Basically they run through a before after comparison and creates the history record with this information.

It IS...

No bottlenecks right now, but because SQL keeps releasing resources reports are slower than they need to be.

We just have years of history that is still reported on in...

Yes, no doubt.

Currently we have only a portion of our users on this system and the DB choked with on a single 8-core 16GB and both MDB and LDB...