Thanks for the response

Another concern is the alert that we get if CPU usage is very high or Disk is busy more than 50% ...

As a DBA , I...

Here's an XML approach.

declare @t table 
(
RowID int identity,
line varchar(80)
)

insert into @t (line)
select 'BSNC001481905191912080000001 PEE5P01 124650005 EMU 090D P' union
select 'BSNC002647745191912080000001 PTE5P02 146650455 RTY 094D Q'

;
with...

Go to Norway and get a reindeer steak... amazing

except that I got a lecture from my mother saying that I had killed Rudolph and spoiled Christmas for all the kids

just keep going - when you are done, maybe write it up and post it to steve… I like a good refresher course on things I haven't done for a...

Hi jeffrey

All good points, a lot of these jobs are multi step - I think i'll test the option to quit with sucess

still - 400 jobs 🙁

It is a big amount of work,  but we also came from an Access system and eveolved - as for the backups, well yes your database will get bigger, but...

amen to customers screwing up CSV files, adding columns etc.  🙂

and I get the  difference in import format files (csv, XML etc) and that you have to create new packages...

I'm not going near anything that uses the words "sour milk", "seal flippers", "sheeps head" or "testicles"

I'd rather swap all of my tables to heaps, remove keys and forget to...

filestream is for storage of files within a filegroup on the database, maybe it would remove your need to get the filenames. the files are contained in the database.

we use...

don't - I went once and it was "an experience" (this is from Wikipedia)

Kæstur hákarl, fermented Greenland shark.

Súrsaðir hrútspungar, the testicles of rams pressed in blocks, boiled and cured in...

• This reply was modified 6 years, 2 months ago by MVDBA (Mike Vessey).

I'm not familiar with sharepoint too much, but is it possible that the GUIDs are  being generated by the sharepoint server? not by SQL

I can only think of 2 options

1. this is not nice (and I don't recommend it) xp_cmdshell 'dir xxx.*.yyy'
2.  difficult option - swap to filestream, but test it first, it...

Actually, you can cheat...

I (occasionally) work with an app like that, thousands of tables,  no foreign key constraints, even better, if you add an index to a table, the next...

I am assuming the solution is a correlated subquery.

Like this example, with the difference that you need to use sum and group by instead of AVG.

This must...