sp_spaceused

Displays the number of rows, disk space reserved, and disk space used by a table in the current database, or displays the disk space reserved and...

Email sent to michelle

For the Sales database and  with the said log growth it sounds obvious that number of transactions are high. In that case I will suggest having Recovery mode full, because...

Hi Asha,

I am Sql Server DBA with experience of 5 years. Currently working with a company in Georgia, previously worked with CSX Transportation,...

Saiju,

 I came out with exactly the same query that Jo Patyn has suggested. Now as it is already posted I am not posting duplication of same query again.

Still I would like...

Hi John,

I have checked the details, and found that it is not any irregularity

but  scripting creates Procedure with

EXEC dbo.sp_executesql...

When you use Group By Clause

make sure to place all columns used in

Select Query.

In your Case column in Group By need to be separated by , not Period...

Fallen Angel,

I am not harsh on responding to any one , but you have driven people crazy with your absurdity.

but here is the copy/paste of your thread,

Now I am...

Sushila,

I have gone through all your post here and found that there was really nothing that I should make  comment like that on you. It was emotional  answer with some feeling that...

Fallen Angel,

What’s your problem. Why  you’re here working with Americans in their company. Your boss is...

Excellent Article.

I Like the way you explain, example helps more than 100' s of lines of description. Obviously the target audience is sql server dba/developer so it's always  good not...