2 votes
Accepted

Can I delete these SQL Server files to clear up disk space?

According to docs.microsoft.com you should not delete the Update Cache folder. As for the Log folder I'd say that you can delete it as long as you do not need the logs stored there.
user avatar
  • 173
1 vote

Records greater than epoch timestamp using only LIKE operator

Realistically, you shouldn't be directly working on JSON data in versions of SQL Server without explicit JSON support. Ideally, the JSON source would be transformed to a relational format during ...
user avatar
  • 70.8k
1 vote

Records greater than epoch timestamp using only LIKE operator

I believe it is best to separate the problem into two parts, locate the update_date and then use ">" to filter: select * from DataTableOne where cast ( substring( data , ...
user avatar
  • 21.3k
1 vote
Accepted

Pivoting 4 by 44 result set

Here is my dynamic solution for this question. I think the issue you are having with the pivot statement is that all of the columns are present when you pivot, which gives you those erroneous NULL's....
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible