seen from Bangladesh
seen from Malaysia
seen from Bangladesh
seen from United Kingdom
seen from United States
seen from Germany
seen from United States
seen from United Kingdom
seen from Canada
seen from Kazakhstan
seen from United States
seen from Malaysia
seen from Malaysia
seen from United States
seen from United States
seen from Türkiye
seen from China
seen from United Kingdom
seen from United States
seen from China
Cycling SQL Server Logs
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…
View On WordPress
The Hidden Cost of ORDER BY NEWID()
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…
SQL Programming Development Company in the USA
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…
View On WordPress
Cost-Effective SQL Server Database Restore on Microsoft #Azure: Using SMB Shares
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…
View On WordPress
Efficient Permission Management in SQL Server: Beyond Cursors
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…
View On WordPress
SQL-Server: Listar todas las tablas de una base de datos junto al número de filas que tienen.
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…
View On WordPress
