very simple....

watch your page life expectancy if this drops below 500 then you should start adding memory.....there are other numbers to look out for as well....but look at the average....at...

hi there....

there is no issue with 64 bit...your system admin is wrong!

you say you are using 3.7 gig, did you run dbcc memory status for this ( check here

yep thats the whole idea...just think of the partition as a table within a table....

we use to keep the last 12 months on ones spindle and the prior years on...

select *

into ERPPLUSDB.dbo.NCMROrders

from ERPDB.dbo.TABLEA

this will create the new table and load it

if you want to clear it each night then you need to run

TRUNCATE TABLE customer

Some things I can think and need help with is:

1. Reindexing online where thats not happening now (we cannot afford more than 10 or 15 min downtime). So, how can...

what are the data types of the columns.

have you tried the convert function

USE AdventureWorks2008R2;

GO

SELECT 'The list price is ' + CAST(ListPrice AS varchar(12)) AS ListPrice

FROM Production.Product

WHERE ListPrice BETWEEN 350.00 AND...

on second thought it wont work....

only thing you might try is the ranking function

If its truly critical?

Then Think about both, both Cluster and log shipping / mirror ...Cluster for high avail and mirror/ log shipping for DR.

I with jack..not trying to bash...

I was not able to find link as well..

I am not so sure there is something out there that will do exactly what you are looking for

This will give the the highest usage SP but then you...

this will get in the right direction, just change the Database Id and table

use this to get your DB_ID --SELECT DB_ID()

SELECT DISTINCT OBJECT_NAME(sis.OBJECT_ID) TableName, si.name AS IndexName, sc.Name AS ColumnName,

sic.Index_ID,...

dont know if they improved the apex yes...but be careful when you start trying to read files that are large it bombs out...so I had to switch to toad.....this was...

I have used this one works pretty good

http://www.toadworld.com/KNOWLEDGE/ToadKnowledge/TipsandTricks/tabid/74/TID/303/cid/38/Default.aspx

good luck

try Inside Microsoft SQL Server 2008 T-SQL Fundamentals and

Inside Microsoft SQL Server 2008: T-SQL Programming

both are about level 300 books....

if you are looking for...

go each of the jobs...right click and you will see view history...you should see lots more....

you could have gotten that because you were doing DB backup and when it was...