Hi Ronnie,

Please try to run this code and post execution plan:

SELECT * FROM LGNCC_ENQUIRY WHERE xref1 = '1001183168' AND objecttype = 'D4' WITH (INDEX(lgncc_enquiry_t2))

Also, what data...

Ronnie.Doggart (3/12/2008)

---

All,

I have noticed that on the customer site the following query uses different plans for different data. So as an example:

Table has two indexes:

index1 is on column x

index2 is...

Ronnie.Doggart (3/12/2008)

---

All,

I have had another look through the profiler trace I have to try and get to the bottom of this issue. The worst performing query took 41 seconds to...

Michael Kaluza (3/11/2008)

---

SQL 2000 SP4 on Windows 2003 SP2

I have a job that updates statistics on 13 databases. This job has been running for a couple of months with...

Hi,

Ok, slightly confused as to why "At some point, on my publisher server, the distribution database lost a reference point"? Can you provide some more information as to how...

julia.nicholas (3/11/2008)

---

I'm trying to figure out a backup strategy for SQL 2005. I need to have a recovery routine that minimises downtime, so I figured I'd go with a...

Steve Cockerill (3/10/2008)

---

We are running SAP on sqlserver 2k5 and having high I/Os.

Does anyone know what the optimum block size would be at the file system level?

We currently are running...

hi,

Where are you running the setup from....Server or Tools folder? If Tools, try running from the server folder.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi Jennifer,

sorry, I missed the last post:-(, but excellent result!!

It's been a complete pleasure.

Take care,

Phillip Cox

MCITP - DBAdmin

Hi Jennifer,

Any progress?

I will create a test setup later today or tommorrow and let you know results. Sounds like you have configured everything properly, so I am at...

Hi,

I agree with donpolix, you wouldn't want a backup of a mess, but if time and space permit, do a backup before applying changes.

Thanks,

Phillip Cox

MCITP - DBAdmin

Hi,

To strenghen your case, ask your manager what the Recovery Time and Recovery Point Objectives (e.g. RTO and RPO) are for the company database and cross-check whether the current backup...

Hi,

It's an excellent investment for any SQL Server DBA and\or developer!

Thanks,

Phillip Cox

MCITP - DBAdmin

john fox (3/11/2008)

---

Hi folks,

Just wondering if anyone can offer me any advice on a new SQL server

setup I am putting together. We are trying to squeeze as much

performance out...

hey,

Sound like you have just completed a software application design course and trying to piece together the different phases of development. If SQL Server is your RDBMS of choice...