New answers tagged

6 votes
Accepted

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.9k
5 votes

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
0 votes

Using Extended Event For Tracking Updates To A Table

For anyone who doesn't have the SQLAudit functionality from this answer available, and is doing this kind of thing purely with Extended Events: there are more events you should be watching than just ...
user avatar
0 votes

Not enough server storage is available to process this command - RESTORE DATABASE is terminating abnormally

I experienced this issue just yesterday. Let me explain my scenario. I would like to restore 10+ dbs from one physical machine SQL Server 2008R2(Windows Server 2008R2) to another physical machine 2016(...
user avatar
  • 1
3 votes

nslookup returning secondary IP of a listener (different subnet)

If you’re using the default cluster settings, DNS will return all registered IP addresses of the listener, not just the one of a specific subnet. If the client application is multi-subnet aware, it ...
user avatar
0 votes

SQL Server Upgrade + BPE

At the least, the Microsoft Books Online for Editions and supported features of SQL Server 2019 (15.x) state that the Buffer Pool Extension feature is still available in SQL Server 2019 in both the ...
user avatar
  • 24.6k
0 votes

Copy SSRS reports to another server

From this question: SQL Reporting Services - COPY reports to another folder I found this tool can both download and upload reports. Plus it lists out folders and subfolders on both the source and ...
user avatar
  • 101
0 votes

What are SHOWPLAN permission security risks? (MS SQL Server)

There are some edge cases where you could use the plan to extract confidential informations. If you write a SELECT COUNT(*) from dbo.employees WHERE salery > 5000 and just show the estimated plan ...
user avatar

Top 50 recent answers are included