Or better yet, is there a query or command I can run to see how much space each object is taking up in the DB? That approach might be better,...

Hi I wish I could ask that DBA but he has since moved on, that's why I am coming to you guys 🙂

Can I see how much space a table/index...

Referring to the data above, I should have mentioned that I dont even know how high the numbers are supposed to go before they are a problem.

Hi, I ran that query in the link and got this:

wait_typewait_time_spctrunning_pct

PAGELATCH_EX2284365.7156.5256.52

ASYNC_NETWORK_IO869947.9921.5378.05

CXPACKET475977.9911.7889.83

OLEDB166699.774.1293.95

LATCH_EX70083.501.7395.69

PAGELATCH_SH49057.881.2196.90

SOS_SCHEDULER_YIELD48003.851.1998.09

CMEMTHREAD38781.880.9699.05

We are using a product called Load Runner which is simulating users going into the app and running things, and...

Hi Lynn,

But how do I know the order which the data in the view is ordered? I mean if table 1 is indexed on column 1, indexed on table 2...

They are really not clear with the objection. They say that if SQL Server goes down, so does Database Mail, and my response is that if SQL Server goes down,...

Anyone?

HOLY CRAP LUKE THAT IS EXACTLY WHAT I NEEDED TO SEE

The configuration page had the number of retry attempts which was set to 3 (I guess by default). I changed...

Exactly what I am talking about, and yes I am contacting our SMTP group to discuss that, BUT NOW I HAVE ANOTHER ISSUE:

When there is a bad email, Database Mail...

Yes, actually this particular index is only one page. . . while the heap is 11.

so what does this actually mean then? Can't the data on a single page be...

How do I determine the index name that it is given the index ID for. . . I have multiple indexes on this table and dont know which one it...

What do you mean by reorganizing? All I know is defragging. . . :unsure:

Well, I've played around some bit and found that the optimizer really prefers to go to the Clustered Index in just about every case unless every column is mentioned in...

Here's an example of what I am looking at:

XPKDEACTIVATE_SOFTWARE_USER_DETAIL

nonclustered, unique, primary key located on PRIMARY

DEACTIVATE_DETAIL_ID

and what I want to add is

C_DEACTIVATE_SOFTWARE_USER_DETAIL

clustered located on PRIMARY

DEACTIVATE_REFERENCE_ID, SOFTWARE_ID, SOFTWARE_UI

Should I remove the constraint,...

I imagine that would be okay, but have zero experience in encrypting anything and really don't know where to start. I've seen where the value passed looked excrypted, but don't...