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,407 reads
Greg Milner
2010-06-29 (first published: 2010-06-09)
1,039 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
534 reads
Blogs
Simple-Talk Article…Understanding Azure Storage Options
Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...
T-SQL Tuesday #120 – Recap
The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...
Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Union with temp table
insert into dbo.details ( DetailId ,DetailName ) select distinct st.stdid ,st.name from dbo.student st...
need help with a query to avoid while loop
i am struggling with a query to avoid while loop, please guide me if...
Ask SSC