Get Rid of All Those Pesky 1 MB File Growth DB Files
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
2013-05-31 (first published: 2012-11-10)
1,425 reads
Greg Milner
2010-06-29 (first published: 2010-06-09)
1,104 reads
Left pad any string with another char
Pads a string (e.g. a number that needs left padding with zeros) with any character for as many as it takes to bring the inputted string to the total desired length.
2002-05-01
541 reads
Blogs
Why i use a smaller docker image part I
What is Docker? Docker is a famous platform for building, shipping, and running container...
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Forums
Find specific string in column and retrieve text that follows it
I have a table contains 2 fields , objid and COMMENT as below: objid ...
SSIS Installation Issues
Hello all, I am attempting to install the SSIS package into VS2019 CE. I've...
SQL blocking caused by running ALTER VIEW script
Hello experts, One of our developers tried to alter a view and reported to...
Ask SSC