First of all, sys.sysprocesses is deprecated, so you should start using a DMV instead of this compatibility view. I think the sum of the reads and writes columns from sys.dm_exec_sessions...

A lot of skills may help a DBA. I won't say that DBA's should posess these skills, but it gives an idea of some skills which may be beneficial for...

Absolutely not. There is a performance hit with shrinking the log file...

Nice to see that I am nobody 🙂

Just out of experience: Are you running the reports against the same database/cube, with the exact same parameters? It is easy to overlook some slight differences in the parameters, which...

Configuring the Reporting Services Service Account

I completely agree. The one and only way to disable access from a specific server is a fire wall rule denying connections from all IP addresses of the server(s) that...

Precision, Scale and Length

This page does not cover it entirely however, as it does not say anything about joins of text columns. However, the comparison operator for joins follow the...

You mean something like this

select

SUM(pages_allocated_count)*8 as MemKB,

type

from

sys.dm_os_memory_objects

group by

type

order by

MemKB desc

select

SUM(pages_allocated_count)*8 as MemKB,

type

from

sys.dm_os_memory_cache_entries

group by

type

order by

MemKB desc

I too fear it is Entity Framework. From a database perspective, I simply hate it. I really really hate it when i see a solution sending some 4000 single inserts...

tt-615680 (11/16/2011)

---

Here is my scenario:

We have an application which we use C#, but the way the Architecture for creating the Application is that only Views can be used to...

I completely agree with Dev, but to help a bit with terminology. Normally, I would say that we call or execute functions and procedures, as they are executable objects, and...

Before getting to a possible solution, I'll steart with the part you don't like. What defines a week? Well, clearly a week is seven days, but whether it is sunday-saturday...

I tend to use NICs from the server vendor, as it allows me to use the server vendor's tools for configuring, monitoring and troubleshooting the NICs. If you plan to...

Not meaning to be rude, but to me this configuration makes absolutely no sense at all. As I understand it, you have a single HBA with two ports, where you...