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,419 reads
Greg Milner
2010-06-29 (first published: 2010-06-09)
1,079 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
539 reads
Blogs
Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Get SQL Server 2022 Now: It’s Called Azure
If you’re like me, your palms went into a cold sweat to get your...
Daily Coping 29 Nov 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Get Summary Data for Last 52 weeks by Week
I have a table which stores shipment data by date. We have a need...
create index columnstore
hello , Who has any idea please how to rebuild a clustered index to...
Ask SSC