Grant good question so far testing has been on Server with DBs all in SIMPLE recovery mode. It does have the option for Point in time recovery, but I'd have...

Hi Thanks for replying.
The tool (I believe is called UniTrends) is being used for file backups. It has a SQL plugin (windows service/agent) which I've installed on an SQL...

Thanks
Yes the SP is in the same DB as the tables.

I wonder if somehow "delete from tbl" could find its way in the table. I would hope...

Hi
The table does store SQL in one column. third party software cannot be changed.
The...

First thank you v.much, without your suggestion of type conversions I wouldn't have found it.

The main view joined to a customer orders view

Create view...

Thanks 
A quick look indicates in the view no implicit type conversions on join criteria or where clause - however there are many in case statements e.g.
[code...

Is formatIDX_Providers a table, if it were a view you could look at it's defintion

Admin was the trick for me on 32 bit.

Have a look at

Posted by Lowell.

Do not like the idea of inprocess though

Hi

I believe that to connect to Office documents you need to use a password (even if the doc doesn't have a password)

Linked server properties --> Security tab

"Be made with...

Thanks John, you are right, another DB would be best, but not an option 🙁

The large big db gets backed up daily.

Say I restore monday's full backup (30GB) to...

Thanks for taking the time Jeff. A server and SQL upgrade are in the pipeline.

I've seen posts about SQL2012 & 2014 having issues with rebuilding indices w.r.t corruption.

First time...

select 'Item A' item, 1 qty

into #t

union all

select 'Item B', 5

union all

select 'Item C', 3

union all

select 'Item D', ...

Positively obese

Maybe I should bite the bullet and make the PK (varchar(12)) a clustered index.

Inserts happen in random order with respect to PK values. So it would become fragmented quickly. A...

Thank you Gianluca

I checked the forwarded pages about 3% of total pages in the heap (a rebuild would help I think).

There are No deletes on this table.

Looks like I'll leave...