Viewing 15 posts - 31 through 45 (of 140 total)
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...
November 26, 2018 at 4:14 pm
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...
June 1, 2018 at 11:55 am
Hi
The table does store SQL in one column. third party software cannot be changed.
The...
June 1, 2018 at 8:33 am
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...
January 26, 2018 at 7:15 pm
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...
January 26, 2018 at 6:12 pm
Is formatIDX_Providers a table, if it were a view you could look at it's defintion
July 19, 2016 at 2:34 am
Admin was the trick for me on 32 bit.
Have a look at
Posted by Lowell.
Do not like the idea of inprocess though
July 19, 2016 at 1:54 am
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...
July 18, 2016 at 12:48 am
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...
June 22, 2016 at 9:01 am
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...
May 30, 2016 at 8:34 am
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', ...
March 11, 2016 at 6:07 am
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...
March 8, 2016 at 7:21 am
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...
March 8, 2016 at 7:17 am
select UPPER(tc.FName + ' ' + tc.LName) AS Coun,
SUM(CASE WHEN Expensetype = [Accommodation] THEN ISNULL(Expense,0) ELSE 0 END) Accommodation,
SUM(CASE WHEN Expensetype = [Flights] THEN ISNULL(Expense,0) ELSE 0...
March 8, 2016 at 6:55 am
Viewing 15 posts - 31 through 45 (of 140 total)