Posts by Jean Braz • 187 points
6 posts
-
1
votes1
answer1108
viewsQ: backup of the sql database structure
Good morning, I have several servers that I use in my development environment, but I would like to know if colleagues know any tool or procedure in the sql itself that I can only backup the Database…
sql-serverasked Jean Braz 187 -
1
votes3
answers36844
viewsQ: return of decimal places in sqlserver queries
In the query below I would like to return only 3 houses after the comma for the columns: size in Mb, availablespaceinmb Already for column available, I would like to return without any decimal place…
sql-serverasked Jean Braz 187 -
6
votes1
answer967
viewsQ: Monitor space in sqlserver datafile
Usually I don’t let the databases grow automatically up to the disk boundary. Therefore, I would like to know if colleagues have any Procedure so that I can monitor and be alerted of when the space…
sql-serverasked Jean Braz 187 -
4
votes1
answer3184
viewsQ: How to know the permissions of a scroll in SQL Server
I am administering some Databases that were created before my arrival. In most of them was created a role called dp_role_analista, and some users are in this role. How do I know what permissions…
-
3
votes0
answers71
viewsQ: How to use @sqlstatement in SQL Server
As I can make better use of the @sqlstatement variable in SQL Server, I couldn’t understand what its real function is. Please explain to me and leave some examples? I ask that if possible do not use…
sql-serverasked Jean Braz 187 -
2
votes1
answer3962
viewsQ: How to bring only results from the last 30 minutes
I have a table in sqlserver that will be logged error logs in which it contains the following fields: sequence date message I would like to know how to get the results of the last 30 minutes…
sql-serverasked Jean Braz 187