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.
- 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 ...
- 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
, ...
- 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....
- 7,776
Only top scored, non community-wiki answers of a minimum length are eligible