Indianrock (8/5/2010)

---

This is more about " do the auditors have the right to ask us questions," than "how do we verify that what we're saying to them is...

harry79 (8/5/2010)

---

We have a very huge table in Development Database.

So Each night, we want to delete data from this table in small batches.

Here are the specs:

•The...

Indianrock (8/5/2010)

---

In our case the auditor was asking basic questions about restoring backups from tape occasionally to verify their integrity and the manager was giving him the evil eye as...

There is no law that says that you have to answer their questions, but it can cause problems.

SAS 70 is an auditing standard designed to enable an independent auditor to...

This script should give you the information you want.

Script to analyze table space usage within a database

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

Try this query:

select

[OBJECT_NAME]= left(quotename(rtrim(a.[OBJECT_NAME]))+

quotename(rtrim(a.[COUNTER_NAME]))+

case

when rtrim(a.[INSTANCE_NAME]) = '' then ''

else quotename(rtrim(a.[INSTANCE_NAME])) end

,60),

[Memory GB]= convert(decimal(10,3),round((a.[CNTR_VALUE]+0.000)/(1024.000*1024.000),3)),

[Memory MB]= convert(decimal(10,3),round((a.[CNTR_VALUE]+0.000)/(1024.000),3))

from

master.dbo.sysperfinfo a

where

a.[OBJECT_NAME] in ('SQLServer:Memory Manager')and

a.[COUNTER_NAME] in ('Target Server Memory (KB)','Total Server Memory (KB)' )

Results:

OBJECT_NAME ...

I believe the latest version of PSTOOLS brings up a license dialog the first time you run it, so you might try logging into that server with the service account...

You can use the 8.3 compatible name for the directory, PROGRA~1 for Program Files in the example below:

dir \\MYSERVER\c$\pr* /x

Volume in drive \\MYSERVER\c$ is MYVOLUME

Volume Serial Number is...

kmonroe (7/30/2010)

---

I just wanted to throw this out there...

I think I have a third party vendor that is trying to give me the run around about a process that their...

These scripts will give you infomation on the size of your database files, including the used and unused space, and show the amount of space used by each table in...

Use DBCC SHOWCONTIG

These scripts should give you the information you are after.

Get Server Database File Information for all databases on a server

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

Script to analyze table space usage within a database

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

Load-balancing can...

SQL Server 2008 has no true load balancing, meaning having multiple database servers actively updating the same database.

There are possible ways to off load specific tasks to other servers. ...

James Stover (7/26/2010)

---

OK, this is going to come across really crude but....surely some of the best "thinking time" has to be sitting on the toilet. When else do you get...