Is this for the entire length of the shutdown of server

dynamic view sys.dm_io_virtual_file_stats

So if not shutdown for 60 days have to divide this amount by 60 or so.

SQL Idera tool.............gives these measurements. There only two disk on SAN being used Data and Logs so i need to determine from SAN Guys what raid. I need...

SQL tool shows this value which is very high to me.

Here something i use it sends email but makes it look pretty like excel.

DECLARE @Emailrecipients varchar(MAX)

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER OFF

SET @Emailrecipients = 'someone@x.com'

DECLARE @tableHTML nvarchar(MAX) ;

SET @tableHTML =

N'TD{font-family: calibri;...

If this is a table with login in side of it and not the SQL Logins

i.e mytablelogins then you can create a role which is under database, security, users,...

I not sure there is a tool that would go through your code i.e

for qty and pass in these values and see if is meet.

If qty > 0

begin

...

In sql manager in properties there is min and max for memory - set the max to say 10 GIG if you have 16 GIG so you leave 6 GIG...

Perhaps using a CAD package with the 3D size of the boxes and then you can put the bottles in there.

Yes your test data on every part of the script to ensure it is met.

Better to test every line of code before it goes into production and ends up in...

I had this and it wasn't SQL it was the wmiprvse.exe this that would spike to 100% during the day and i believe it was from one of the latest...

Gives 33 records so added another part of the key UDEF_LBL_KEY

I included another part of key

SELECT T2.*

FROM TESTDATA T1

INNER JOIN CUST.TABLE2 T2 ON T1.GENL_ID = T2.GENL_ID AND A.UDEF_LBL_KEY =...

Inside of your cluster administration you see

SQLCLUST

Cluster Group

MSTDC

VSQL01

VSQL02

Then

SQL01

Active Groups

SQL02

Active Group

So users connecting to SQL Instance is...

Windows 2008 Cluster for SQL 2008 Failover.

When configuring the DISKS for active/passive.

Do you configure the DISK Management for the SAN identicial on both NODES.

i.e if have disk F, K, L...

Reading

http://www.mssqltips.com/tip.asp?tip=1687

When it mentions the Nodes i am thinking this means the server name itself.

Add Target Portal enter DNS of your iSCSI Target (Is this the IP address...

Thanks for script - is there a way to get the TABLE that is locked also i see object and ID but get internal in OBJECT