Try to configure firewall on W2012 server...

You can find big table(s) (http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx ... modify script for system objects also).

SQL Server 2005

select physical_memory_in_bytes,virtual_memory_in_bytes from sys.dm_os_sys_info

Try this http://support.microsoft.com/kb/955496%5B/url%5D

If you want change the SQL Server service account, use "SQL Server Configuration Manager".

Lowell (1/23/2011)

---

can you check the version of the instance you are connecting to? it might be that that instance is, say RTM, but your client tools are using SP4 or...

Try modify this code (this visual basic script reads the SQL...

Steve Jones - SSC Editor (1/12/2011)

---

You can compare integer and varchar in some cases. An implicit...

s.CustodianID and s.FundAccountantID and s.BrokerID are probably integer.

You cannot compare between integer and varchar.

Elliott Whitlow (1/10/2011)

---

Yes, it is.. An EXISTS check completes...

It is not nice, but it can be fast.

IF @ContactType = 'Broker'

Begin

SELECT DISTINCT

c.ContactID,

c.ContactName,

c.PhoneNum,

c.Fax,

c.PersonalEmailAddress,

c.CompanyPhoneNum,

c.GroupEmailAddress,

c.Address1,

c.Address2,

c.Address3,

c.Address4,

c.City,

c.State,

c.Zip,

c.CountryCode

FROM

tblDCF_SubAccounts...

I need only one row (top 1), if i use "EXISTS". Is Optimizer so clever to eliminate other potential rows?:-)

I prefer:

IF EXISTS(SELECT TOP 1 1 FROM ...

Try some indexes. 3 millions records... it is small table for partitioning.

You need monitor executing sp_purge_jobhistory like this:

declare @dt datetime

select @dt = getdate()-30

EXEC msdb.dbo.sp_purge_jobhistory @oldest_date=@dt

Alternative method: save this code as filename.vbs and run as cscript filename.vbs

[p]

'*****code *****[/p]

[p]strComputer = "."[/p]

[p]strStr = ""[/p]

[p]Set objWMIService = GetObject( _[/p]

[p] "winmgmts:\\" & strComputer & "\root\CIMV2") [/p]

[p]Set...