External Article

Controlling Growth of an msdb Database

  • Article

I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain maintenance information for the database such as backups, log shipping and so on.


2,711 reads

Technical Article

converting to datetime data type

  • Topic

year=2005 Month=5 day=27 time=9:30I have these values with me and I wanted to convert this to a datetime field.SELECT CAST(year AS varchar)+'-'+CAST(month AS varchar)+'-'+CAST(day AS varchar)+' '+CAST(time as varchar)+':'+'00'  FROM tabI am trying to convert this into datetime by using the above quesry.But I wanted to convert month 5 as as 05 and time 9:30 […]


Technical Article

RE: dev's using sa on production - help

  • Reply

I had a similar problem and the same discussion. In the end I reached a compromise which was to take away the use of sa by changing the password and not telling anyone and agreeing that in time they software suppliers may need sysadmin on the box but and I would have to agree with […]


Technical Article

RE: A Brief History of SQL

  • Reply

More of the topic in: Without Codd's (, Ellison ( will not be flying his jets by now.. What do you think of his GRID computing?


1 reads


Query Store Hints in SQL Server 2022


Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Daily Coping 30 Nov 2022


Today’s coping tip is to learn a new skill from a friend or share...

Encrypting Your SQL Data Should be Your Default Option


Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Read the latest Blogs



By Anita Lakhani

I have some IT peeps that will run an SSIS package manually from a...

Technical support for SQL Server

By Ram

Hi, Do we have to pay for  opening a support ticket with Microsoft for...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers