Hi Steve

Sorry I still don't understand what you mean by

" write code that looks for count(lookup value) = count(*)"

Thanks

Steve

Hi

Before any fixes that you think are "essential", make sure your manager agrees the priorities, in particular new work vs schema fixes, backups, reindexing or DBCCs etc

Only do essential fixes...

PS

Sorry, this time including some sample data

CREATE TABLE [dbo].[MyStatus](

[Status_Id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,

[StatusDesc] [varchar](25) NULL,

)

INSERT INTO MyStatus VALUES ('Active')

INSERT INTO MyStatus VALUES ('OnHold')

INSERT INTO MyStatus VALUES...

Hi Suresh,

Thanks for your post but there are some possible problems if you start to use ORDER BY.

See

http://stackoverflow.com/questions/9938853/order-by-when-concating-a-varchar-does-not-work-as-expected?rq=1

for example

DECLARE @MyStatusList VARCHAR(MAX)

SET @MyStatusList = ''

SELECT @MyStatusList = @MyStatusList...

-- Along the same lines, this is a very simple way of listing invalid data (allowing -_,;@' in the email column)

DECLARE @match VARCHAR(30)

SET @match = '%[^a-zA-Z0-9@.,;!-!_!'''']%'

SELECT email ...

Hi Steve

Are you missing the data for the buffer cache hit ratio graph?

Steve

For years I have tried to get silence, finding that music (and all other types of noise) really cuts into my ability to focus.

Recently however, I discovered that white noise...