Jeff Moden (11/23/2008)

---

Not my idea, but... find's files for current database and makes a report of used, unused, and total size...

select [FileSizeMB] = convert(numeric(10,2),round(a.size/128.,2)),

[UsedSpaceMB] = convert(numeric(10,2),round(fileproperty( a.name,'SpaceUsed')/128.,2))...

This script will tell you the size of every table in a database.

Script to analyze table space usage

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

I don't understand why the OP is even posting his code here.

His failure to answer any of the requests for information on the expected results makes it impossible to offer...

The thread in that link seems to be about the amount of free space on the drives, not about the amount...

What do you want it to return if today is Sunday, today...

dphillips (11/20/2008)

---

Michael Valentine Jones (11/20/2008)

---

How about telling them the guy who was keeping the records of the backup tapes left years ago, was never replaced, and you don’t have any...

How about telling them the guy who was keeping the records of the backup tapes left years ago, was never replaced, and you don’t have any idea how to find...

There are a lot of people that post questions where they don’t even know how to ask the question, can’t make themselves understood in English, probably shouldn’t be working with...

The fastest way to get started is to use the Maintenance Plan Wizard.

You should also ready about Backup and Recovery in SQL Server 2005 Books Online.

The code below has a couple of options you can use:

select

next_run_date,

right(10000000+next_run_time,6) as Time1,

stuff(stuff(right(10000000+next_run_time,6),5,0,':'),3,0,':') as Time2

from

msdb..sysjobschedules

Results:

next_run_date Time1 Time2

------------- ------ --------

20081119 ...

Take a look at the stored procedure code I posted on this link. It should meet all the requirements you stated.

Generate Password Procedure

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78859

Have you verified that the tables that you don't see improvement on have clustered indexes?

There is some performance hit to running on a VM, but it is hard to predict exactly what it will be. You are sharing real hardware with other VMs,...

"My understanding is, a primary key should be not null and uniquely identify each row"

A primary key must be not null and must uniquely identify each row.

"Is there like a...

If you can, convert your ntext column to nvarchar(max), and you won't have to worry about updatetext or writetext. You can just use regular string functions and operators.