Douglas Osborne-229812 (8/8/2012)

---

Donalith - I disagree - usually the second I create the index they are used an not 'resuggested.'

I'm going to reboot, run

DBCC dbreindex ([tblInvoices])

UPDATE STATISTICS [tblInvoices] WITH FULLSCAN

And...

Have fun! 🙂

You'd need some way in Access to execute T-SQL (or equivalent) rather than calling a proc.

I don't use Access so I've no idea if it has that ability, sorry.

e.g. Create...

pdanes (8/9/2012)

---

You mean create a permanent table that would stay in the database? I...

The </customerrors> from that tutorial isn't right as far as I can tell!

Instead of

<system.web>

...

<customerrors mode="RemoteOnly" defaultRedirect="http://yourwebsite/Reports/Pages/test.html">

</customerrors>

...

</system.web>

Try:

<system.web>

...

<customerrors mode="RemoteOnly" defaultRedirect="http://yourwebsite/Reports/Pages/test.html" />

...

</system.web>

Cheers

Sounds like an interesting problem!

I might be oversimplifying this, but is the purpose of each step just to refine the selection criteria (i.e. your WHERE clause)?

If so, would it be...

Sean Lange (8/8/2012)

---

And take the suggestions for indexes with a grain of salt. The suggestions are not always good ones. You need to test actual performance before and after adding...

Not 100%, but I think selecting Overwrite on the option 'If Backup files exist:' implies FORMAT.

There's a bug which means SQL will continue to suggest the index, even after you've created it.

After you create the index, has the execution plan changed to use it?

Cheers

Me too... 🙂

I think the OP means this:

SELECT CASE WHEN Col1 IS NULL THEN 0 ELSE Col1 END + CASE WHEN Col2 IS NULL THEN 0 ELSE Col2 END ?

SELECT ISNULL(Col1, 0)...

You'll need to do it in SQL unfortunately, returning NULL or 0 or 'None', whatever's appropriate.

Fixed data property is for keeping the data onscreen while scrolling.

Are you synchronising data and/or structure?

What is the purpose of the second server - High Availability, Disaster Recovery, Reporting, Test/Development?

Thanks

MS SQL implicitly casts a blank string into 1900-01-01 00:00:00 in datetime data type so you're a bit stuck there.

Not sure why the NULLs are a problem though in your...

+1

Do this before rebuilding the indexes - IIRC, checksums are only written when the data/index page...