Viewing 15 posts - 31 through 45 (of 629 total)
All scripted. Backups, overnight checks, alerts, DBAUtilities database, tools (sp_blitzX, sp_WhoIsActive), monitoring jobs, MaxDOP and other non-standard settings, backup locations. There are some minor hand tweaks - IFI, TempDB and Model...
September 14, 2018 at 7:06 am
September 14, 2018 at 3:47 am
September 14, 2018 at 3:45 am
Ok, so the first argument would appear to be able to be summarized as "I have no idea what a database really does, or how to use one effectively ......
September 13, 2018 at 5:12 am
Heaps, in my experience, have very limited applications in a competently designed system. Staging tables in ETL, but even then for loading only, once you start working with them you...
August 1, 2018 at 2:44 am
July 20, 2018 at 3:10 am
Well, then the people I say no to must be unprofessional. They seem...
July 19, 2018 at 8:05 am
July 18, 2018 at 10:34 am
July 10, 2018 at 9:35 am
July 10, 2018 at 8:09 am
June 12, 2018 at 3:52 am
June 12, 2018 at 3:23 am
Glad it was helpful.
Just in case you're not familiar with setting up filestreams to ensure best performance, the following link
Considerations for Filestream Configuration may be of help. ...
May 29, 2018 at 9:22 am
It's something we've done at my current place. As the files in this system are quite small, they've been stored in a SQL Server table (partitioned due to the volume...
May 29, 2018 at 4:34 am
Viewing 15 posts - 31 through 45 (of 629 total)