I am intelligent and I have no varchar of 1 billion characters.

Also, in my designs, there is usually no place for varchar. In that case, I would use...

That will only clear space if it happens to be free at the end of the file. As the data you...

IF OBJECT_ID('dbo.INFGenerateInsertStatement','P') IS NULL BEGIN
    EXEC ('CREATE PROCEDURE dbo.INFGenerateInsertStatement AS')
END
GO
-- *****************************************************************************
-- Sample call
-- EXEC dbo.INFGenerateInsertStatement 'XXXXXXXXX', 'dbo', 'Integration%', 0
-- *****************************************************************************
ALTER PROCEDURE dbo.INFGenerateInsertStatement
(
  ...

Have you got a Microsoft link that states this?

With 550 columns it's not possible to test every combination of 2 or more columns to see if they are unique. It's a combinatorial problem with a search space of...

I thought you could just open a 2008 database in 2017?

This gives the results you have requested. But you can't guarantee these results if you have nothing concrete to order the data by.

;WITH CTE AS 
(
 ...

Here is a demonstration that the locking hints work. You will need to create a permanent version of Jeff's table (dbo.Codes) as the procedure will be run from different sessions.

With...

Hello,

I have the following queries that I want to group together in one optimized query. I would like to compare the difference between movements and balances with movements and...

I think you just need to write a stored procedure that's called when a new code is to be allocated.

It just needs the correct locking hints specified on the...

there's one exception - your log file grows stupidly big and...

I don't think it'd a good idea to have more than one log file for a database:

https://www.sqlskills.com/blogs/paul/multiple-log-files-and-why-theyre-bad/

Try doing

select TOP (50000) * from EXT_data_Hist_TbL

on each database, without anything in the WHERE or ORDER BY, and see how many reads it does.

I think this is a direct conversion of your SQL, just subtracting 2 inline SQL statements:

SELECT (SELECT count(p.[peopleId])
         ...

Grab a copy of NGrams8k and you can do this:

Declare @Temp Table(SomeId INT IDENTITY, [Data] VarChar(8000))

Insert @Temp ([Data])
Values('hello my name is john 07999999999 smith...