dkschill (4/8/2013)

---

Here is the build script:

CREATE TABLE [dbo].[item](

[item_urn] [int] NOT NULL,

[cat_urn] [int] NOT NULL,

[item_mnc] [varchar](10) NOT NULL,

[item_descr] [varchar](50) NULL,

[item_active] [char](1) NULL,

[item_device] [varchar](20) NULL,

[item_type] [char](1) NULL,

[dept_urn] [int] NULL,

[modified_by] [varchar](16) NULL,

[mod_timestamp] [datetime]...

Please post the table and clustered index definition and the entire row for the index from the physical stats DMV run with DETAILED analysis.

There is little point to rebuilding an index with only 368 pages. The general consensus is not to bother with indexes that have under 1,000 pages.

As for why an index...

Yes, it's a supported operation.

sqlfriends (4/8/2013)

---

We have a SQL instance with max memory set to 20 GB out of total 24 GB.

Now I would like to install another instance on the server.

Will the install...

Jeff Moden (4/8/2013)

---

opc.three (4/8/2013)

---

Jeff Moden (4/8/2013)

---

opc.three (4/8/2013)

---

If your argument is "someone in the sysadmin Role can take down the system so why bother running a system with xp_cmdshell disabled" then...

Jeff Moden (4/8/2013)

---

opc.three (4/8/2013)

---

If your argument is "someone in the sysadmin Role can take down the system so why bother running a system with xp_cmdshell disabled" then I think you...

Can you correlate the size of the image you're retrieving in query 1 to the number of lob reads, and the same for query 2?

How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager) - SQL Server 2005

EdVassie (4/8/2013)

---

However, having seen the suggestion to use log shipping I think that probably needs the lowest skill level to get it working. As already mentioned it will need...

patrickmcginnis59 10839 (4/8/2013)

---

mister.magoo (4/8/2013)

---

patrickmcginnis59 10839 (4/8/2013)

---

opc.three (4/7/2013)

---

Jeff Moden (4/6/2013)

---

Shifting gears a bit, you've been stressing the auditing aspect of things. What type of system auditing do you currently have...

patrickmcginnis59 10839 (4/8/2013)

---

opc.three (4/7/2013)

---

Jeff Moden (4/6/2013)

---

Shifting gears a bit, you've been stressing the auditing aspect of things. What type of system auditing do you currently have setup on your...

You keep throwing this one back into the conversation...

Jeff Moden (4/4/2013)

---

My question would be, why would anyone worry about a DBA doing his/her job? 😉 Being a DBA requires you to do things like this. Some...

As long as one is fully aware of the associated security risks and auditability shortcomings, preference is a fair and honest reason to use xp_cmdshell.