Posts grid page

Índices não utilizados
February 11, 2014

A melhor maneira de verificar a utilização ou, neste caso, a falta de utilização dos índices em SQL Server é através Continue reading

Optimização SSD
February 10, 2014

Para optimizar o funcionamento dos SSD em Windows devem ser feitas algumas configurações:

Desligar Hibernação (para não utilizar o hiberfil.sys): "powercfg.exe Continue reading
Instant File Initialization
February 1, 2014

De forma a aumentar a velocidade de criação ou recuperação das bases de dados, bem como, a velocidade de aumento Continue reading

Antivirus and SQL Server
January 19, 2014

"How to choose antivirus software to run on computers that are running SQL Server" by Microsoft

@ https://support.microsoft.com/en-us/kb/309422

Continue reading
Restore Database
October 12, 2013
Full Recovery USE master; GO --Create tail-log backup. BACKUP LOG AdventureWorks2012 TO DISK = N'Z:\SQLServerBackupsAdventureWorksFullRM.bak' WITH NORECOVERY; GO --Restore the full database backup (from backup set 1). RESTORE DATABASE Continue reading
Locks
September 23, 2013

As in MSDN

Lock modeDescription Shared (S)[/span1]Used for read operations that do not change or update data, such as a SELECT statement. Update Continue reading

Restore “point in time recovery”
February 12, 2013

Litle script to use point in time restore using your transaction log backup:

RESTORE LOG backup_name FROM DISK = 'C:backup_file.trn' WITH STOPAT = Continue reading
SQL Server SP’s e Hotfixes
January 22, 2013

This is the best blog to know the latest SQL Server releases: SQL Release Services Blog

Continue reading