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,409 reads
Greg Milner
2010-06-29 (first published: 2010-06-09)
1,048 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
My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
This is one of those things that probably doesn’t happen all that often, but...
In Memory Table Indexes
Now that I have written about In-Memory Tables and Migrating to In-Memory tables, let’s...
Forums
Trigger for only updating specific column
Hi, using Merge I can sync table A with Table B at ROW level....
SQL Server Licencing Question
This question is about SQL Server Licencing and licencing for Maximum Virtualisation. I'm curious...
Error converting data type varchar to float
All, I know this topic has been discussed numerous times and I tried all...
Ask SSC