#sql-server

Cycling SQL Server Logs

In the not too distant past, Windows servers were rebooted much too frequently for a truly stable environment, but we got used to the practice. With more recent versions of Windows, reboots have become less frequent and it isn’t uncommon to see a server that hasn’t been rebooted in more than 90 days. The issue is that SQL Server is using the same log file during that time, with thousands or even…

Fetching a random row from a table is a surprisingly common requirement — random banner ads, sample data, rotating API credentials. The instinctive solution in SQL Server is elegant-looking but conceals a serious performance trap. -- Looks innocent. Isn't.SELECT TOP 1 * FROM LARGE_TABLE ORDER BY NEWID() What SQL Server actually does NEWID() generates a fresh GUID for every single row in…

LDS Engineer: Premier SQL Programming Development Company in the USA LDS Engineer stands as one of the leading SQL programming development companies in the USA providing exceptional Information base Answers to Customers across the globe. Our party has a stacked amp sound report for delivering top-tier SQL scheduling services to businesses of all sizes and industries. With a dedicated team of…

1) Motivation Behind the Process Managing costs efficiently on Microsoft Azure is a crucial aspect for many businesses, especially when it comes to managing resources like SQL Server databases. One area where I found significant savings was in the restoration of SQL Server databases. Traditionally, to restore databases, I was using a managed disk. The restore process involved downloading a ZIP…

In the realm of SQL Server management, efficiently managing permissions for functions and stored procedures is crucial for maintaining security and operational integrity. Traditional methods often rely on cursors to iterate through each object and apply permissions. However, this approach can be less efficient and more time-consuming, especially in databases with a large number of objects. This…

SQL-Server: Listar todas las tablas de una base de datos junto al número de filas que tienen.

A veces me tengo que enfrentar “a ciegas” a extraer datos de una BD para pasarlos a otra con una estructura distinta (por ejemplo, migraciones de un software a otro). Una de las complejidades de esto es saber qué hay que traspasar, a veces te encuentras una base de datos con 500 tablas y lógicamente no vas a revisarlas una por una. Hay varias formas de comprobar el estado de las mismas, yo suelo…