3 votes
Accepted

how to find out the free space inside a database file when the database is not online?

However, how can you do that when the database is offline? There really isn't an option built in to do this as the allocation management items are in the database. The databases would have to be ...
Sean Gallardy's user avatar
3 votes
Accepted

what sql server is holding in the used memory?

[...] is there a way to find out what sql server is holding in there memory? Yes and no, depending on what you mean by "holding in there memory" (sic). If you mean what's using memory in ...
Sean Gallardy's user avatar
3 votes
Accepted

RESTORE DATABASE - The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time

I remember I had similar problem during the database restore, in my case it were reporting queries that run every 15-20 min and took tens of gigabytes of RAM for memory grants, as well as some extra ...
Aleksey Vitsko's user avatar
2 votes
Accepted

Convert numbers to words | Spell out DECIMAL USD 1259.75 as 'One thousand two hundred fifty-nine dollars and seventy-five cents'

Modify the 100/1000/1000000 "WHEN" portions of the SELECT statement to be like this, and you should achieve your desired result. WHEN @Number BETWEEN 100 AND 999 THEN dbo.NumberToWords((...
Craig's user avatar
  • 136

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