Again... Always best to contact a MS rep on this. However, if I remember correctly, software assurance is for the product purchased. So if you buy SQL Server 2005...

pamozer (4/18/2012)

---

Jared,

So your thought is for all 10000 databases (approx), I should consolidate into 2 Report servers? Can Sql SErver handle that? We expect to have almost double...

charles-1011021 (4/18/2012)

---

the Max(timestamp) is to get the timestamp value of the row modifed in the table.

[LastBarcodeTimeStamp] is Binary(8) because MS said the a timestamp converted to a Binary(8) field

RowCounter...

Sean Lange (4/18/2012)

---

Not really true or an accurate way...

Ok, but there is no WHERE in your SELECT. So you are always getting the MAX from the entire table.

[LastBarcodeTimeStamp] --I assume this column is a VARBINARY(MAX)?

CONVERT(varbinary(max), MAX(timestamp), 1) --Why MAX(timestamp)?

WHERE RowCounter = 1 --What data type is RowCounter column?

ONE MORE! You still haven't told us what is not working... It is not updating? It is not updating correctly? What does "not correctly" mean? Don't make us fish,...

Hmm... Also, why are you using a VARBINARY(MAX)? You do realize that will move all of that data off of the page?

Have you read up on the timestamp data type? It is not "a timestamp," it is a data type called timestamp that is simply unique binary numbers. This has...

I think since it is used in MAX(), it is...

Who is the vendor? Looks like I could sell my skills to them... What a lot of NOLOCKs!

I don't like the open source idea... BTW, open source <> free.

I would design a solution with 1 or 2 reporting servers that get the data replicated to them or...

Going along with Lynn, what is the data type of your timestamp column? Are you getting errors? If so, what errors? Can you run the SELECT CONVERT(...) statement by...

PiMané (4/18/2012)

---

I used this query to determine indexes without "hints" (user_scans, user_seeks, user_lookups).

create view vw_index_usage as

select object_name(a.object_id) "tablename",

c.name "indexname",

c.type_desc "indextype",

case c.is_unique

when 1 then

case is_primary_key

when 1 then

'Primary Key'

else

'Unique'

end

else

case c.is_unique_constraint

when 1...

dsohal (4/18/2012)

---

USE [msdb]

GO

/****** Object: StoredProcedure [dbo].[xp_sendmail] Script Date: 04/18/2012 13:21:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROC [dbo].[xp_sendmail]

@recipientsvarchar(max)=NULL,

@messagevarchar(max)=NULL,

@queryvarchar(max)=NULL,

@attachmentsvarchar(max)=NULL,

@copy_recipients varchar(max)=NULL,

@blind_copy_recipientsvarchar(max)=NULL,

@subjectvarchar(max)=NULL,

@typesysname=NULL,

@attach_resultschar(5)=NULL,

@no_outputchar(5)=NULL,

@no_headerchar(5)=NULL,

@widthint=9,

@separatorchar(1)='',

@echo_errorchar(5)=NULL,

@set_usersysname=NULL,

@dbusesysname=NULL,

--call parameters outside the range of old xp_sendmail call

@profile_namesysname=NULL,

@body_formatVARCHAR(20)='TEXT',

@importanceVARCHAR(6)='NORMAL',

@sensitivityVARCHAR(12)='NORMAL',

@query_attachment_filenameNVARCHAR(260)=NULL,

@append_query_errorBIT=0,...