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...

In this example, I group by the first day of the month, order by that value, and extract year and month from that value.

select

[Year]= year(dateadd(mm,datediff(mm,0,Mydate),0)),

MonthName= datename(month,dateadd(mm,datediff(mm,0,Mydate),0)),

[RowCount]= count(*)

from

( -- Random Test...

I became a DBA when I was older than you, and I'm somehow managing to get by.

There are projects that are so mismanaged that they become a death march that...