• Undocumented Store Procedures on SQL Server 2008

    Posted over 3 years ago
    by SQL by Edinson Medina}
    Introduction Hello, a few days ago I was think that even the high usage that I personally use of the xp_readerrorlog (or sp_readererrorlog) stored procedure to review the SQL Error Log, if do an internet search about it you will not find any official...

  • Stored Procedures No Documentados en SQL Server 2008

    Posted over 3 years ago
    by SQL by Edinson Medina}
    Introducción Hola a todos, hace algunos días reflexionaba que pese al uso común que personalmente hago del stored procedure xp_readerrorlog (o bien sp_readerrorlog) para revisar el log de errores de SQL Server, si realizamos una...

  • SQLOS and Memory Management

    Posted over 3 years ago
    by SQL by Edinson Medina}
    From SQL Server 2005 the SQLOS was implemented don SQL Server. We can see the SQLOS as a layer used by SQL Server to interact with the Operating System. The need to have the SQLOS on SQL Server is given by the need to adapt to changes at the hardware...

  • SQLOS y Manejo de Memoria

    Posted over 3 years ago
    by SQL by Edinson Medina}
    A partir de SQL 2005 se implementa SQLOS . Podemos ver a SQLOS como una capa (Modo Usuario) por al cual SQL interacciona con el Sistema Operativo. La necesidad de tener al SQLOS en SQL viene dada por los continuos cambios a nivel hardware y arquitectura...