One trick I've seen if you don't want to do the entire shrink in one operation is to do the shrink steps in a loop and shrink the size by...

Heh... guess I'm more ancient.  I've not found much that will actually beat BCP...

Because columnstore and non columnstore indexes are designed for different use cases.  And because of that column store indexes are not an automatic solution for performance issues and simply replacing...

Well, I got to the first line of the article "Database UPPERCASE". I just wondered why you should have a database in uppercase? What if it consisted of 2...

What is the context for what you're trying to do, how are you running the export and how big is the data set?  There are a number of options, bcp,...

Have you looked into trying the reverse function?

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it doesn't...

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency, it doesn't get done. ...

SELECT Date,
       SUM([101]) OVER (ORDER BY Date) Acct#1,
       SUM([201]) OVER (ORDER...

SELECT Date,
       SUM([101]) OVER (ORDER BY Date) Acct#1,
       SUM([201]) OVER (ORDER BY Date)...

That is correct. I want to store the content of the Word and PDF in vardinary into SQL server. Also, If can do some parsing using Java script as...

Do you mean you want to store the document as a varbinary in SQL Server and do so from javascript?

Assuming you'll only have 1 record per ID marked with a Y you could do something like,

SELECT *, 
MAX(CASE WHEN NewAddressFlag = 'Y' THEN Address1 ELSE ''...

You do understand that this technique is intended primarily to present information...

This is getting tiring.

Except snapshot isolation does not automatically do what you say as it operates on an individual statement level.  So each subsequent query might still use different...