How to use SQL Server FILESTREAM feature for large databases

Do’s and don’ts   What is SQL Server FileStream feature? This feature allows adding unstructured documents into the database. You can store images, PDFs, videos, or whatever files you want into SQL Server database. This allows to have transactional consistency of images.   We have worked with very large FILESTREAM implementation. And I will show … Read more

How to re-initialize SQL Server Merge replication publication

How to re-initialize SQL Server Merge replication publication 1. Connect to publisher instance: CIXSQL01\TOUCHSTORE. 2. Click right on Replication folder and click on “Launch Replication Monitor” option. 3. Click right on publication that you want to reinitialize and click on “Generate Snapshot” 4. After generating the snapshot go back to Local Replication, expand the publication … Read more

Why Disk (or Storage or I/O) operations matter the MOST when Tuning T-SQL Calls for Performance

Why Disk (or Storage or I/O or R) operations matter the MOST when Tuning T-SQL Calls for Performance “Disk” – has different names. I think that confuses anyone outside of DBA little world. Alternate names some DBAs call Disk (including myself) are: Storage I/O (input output operations) Disk operations or simply “Reads” All of those … Read more