Good idea,
Some CREATE ASSEMBLY STATEMENT comes with the long binary string, some without.
Is this a normal behavior ?
Yes, I want  to avoid, every time specify the same...

Hi,
I think that you should read the article in the link, apply to Oracle, but SQL Server too.
https://stackoverflow.com/questions/25186267/managing-very-large-sql-queries
Good Luck

Jeff,

1. Yes, weekly dbcc,Index reorg and rebuilt, (if the maintenance window allows it).
2. Yes, that is the normal behavior of the app
3. No
4.  ROWS    1971849.500000    -1    262144    0    ONLINE
    ...

Hey,
Just checked again, 147 Gigas :crying:
Largest heap table 1 Gigabyte
:doze:
Thanks for your suggestions

Jeff,
Yes, a primary, unique, clustered index of 146 Mb
Thanks

Hi,
Yes, dear friend, 500 Gb LDF file and 500 Gb physical drive.
Thanks again

Jeff,
LDF file 507.965 Mb
Drive 507.974 Mb
free 9 mb
Thanks for your suggestions

Thanks Michael for your response,
Yes, they are in different disks. So, I will not have nightmares ?
Thanks again

Hi,
My actual resultset is attached, I am only interested in taking the last row per month.
In each month i cycle and get the next last day...
Thanks

Hi,
Have you tried a DBCC OPENTRAN, to identify who is active ?
Best  Regards

Another question would be, How many time I'm supposed to remain in an unsuported OS or SQL Engine version, If I don't have the option to add presurre in this...

Hi,
Always is going to be bad guys, who lilke to take advantage from others or from companies that's the point, Microsoft and other  software companies has to improve his...

Hi,
Sometimes, we  need to leave our comfort zone and learn some new tricks.
Python. R are small changes for Microsoft, but big changes to our community which surely will...

Finally,
I am getting a report, using,  SQL Server  Performance  Dashboard 2012, when you get Current Waiting Requests and hit lock, you get a blocking report.
Now, I am looking,...

Hi,
Thanks for your response, really i am looking for blocking.
I am wondering. How  could  I setup an extended event messaging report. The piece of code I...