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...

that raises an interesting point - I'm slightly misquoting Alejandro here

"memory problems, SQL Server bugs, or IO subsystem"

All of this morning My DR instance has had all 3 of these...

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 be done...

This sounds like a NoSQL situation - basically "eventual consistency"  across many nodes????

am I correct ?

is this causing an issue ? the installation language is pretty much just used for error messages and date formats (as for as I can remember)

your collation will control sort...

you might have to use case statement

for example if I wanted to get a count for all employees who first name starts with 'j'

select sum cnt from

(select  case when firstname...

Another venting.. first thing though, I don't want to get into the whole argument on of using EOM vs BOM.

Where I work currently they use EOM.  Which is fine...

Tends to vary over time. I like some sci-fi, spy...

Jeff

2nd row has data types? I've never seen that before.. but you have no idea what dreams I will have tonight , followed by the nightmares of using the SSIS...

we still use mainframe and AS400.  This is how we get files all the time.  Bulk Insert works well and fast.  I still have arguments with mainframers as they...

good spot.. it's easy to lose a , or ' especially in dynamic sql or badly formatted code