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,410 reads
Greg Milner
2010-06-29 (first published: 2010-06-09)
1,064 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
535 reads
Blogs
When Your Azure Data Catalog App Won’t Connect
By Angela-Henry
This year I created a new presentation for introducing Azure Data Catalog. I love...
Packet Pushers Podcast released
By kleegeek
I am thrilled to have recently recorded a podcast with our friends over at...
Azure Databricks to Azure SQL DB
By Arun Sirpal
Recently I got to a stage where I leveraged Databricks to the best of...
Forums
DBCC Shrinkfile on data file with Availability Group - Is it safe?
I need to shrink a data file on the primary replica of an availability...
SSRS 2014 - Page Break to follow a sub-report?
Hi everyone, Really really need help on this one. You would think that page...
Nested Json Parsing issue
Greetings, I am having issues parsing the following Json string using openjson. I am...
Ask SSC