Are you able to post the view definition, please?

John

Lavanya

Please will you post the script, then?

By the way, you can see what differential backups have completed with this query:

SELECT

r.DBName

,r.type

,r.BackupStart

,s.backup_finish_date

,s.backup_size

,m.physical_device_name

FROM (SELECT

d.name AS DBName

,b.type

,b.backup_start_date AS BackupStart

FROM master.dbo.sysdatabases d

LEFT JOIN msdb.dbo.backupset b

ON...

That's not entirely true. You can run a log backup while the...

I think I would create a lookup table, like this:

CREATE TABLE CodeActions (

Code char(4)

,TheActionvarchar(12)

)

INSERT INTO CodeActions (Code,TheAction)

VALUES

('ISSP','Install'),

('IECO','Install'),

('IECM','Install'),

('IESP','Install'),

('IEHD','Install'),

('ISHD','Install'),

('FRSI','Install'),

('SB42','Service Call'),

('SB4W','Service Call'),

('HD42','Service Call'),

('HD4W','Service Call'),

('SA2C','Service Call'),

('SA2W','Service Call'),

('HD2C','Service Call'),

('HD2W','Service Call'),

('SNCO','Service Call')

That way you don't have...

Is this being done as part of a maintenance plan? My guess is that something other than the backup itself is failing - possibly the removal of an old...

Lowering the fill factor can improve write performance by reducing the number of page splits. It can impair read performance by requiring a larger number of pages to be...

Thanks SQLBalls, Jon and ACinKC. That makes it a little clearer. I guess as a beginner I'll understand more as I read more and more of the articles...

No, it won't affect...

Thanks for the beginner's guide, Rob - very much needed in my case! I have one question on this. Are elements and attributes functionally equivalent? For example,...

Of course you do, because it's not 2004 any more.

Here's a third alternative:

WITH Totals(Yr, TotalDueForTheCurrentYear, OverAllTotalDue) AS (

SELECT

YEAR(OrderDate)

,SUM(TotalDue) OVER(PARTITION BY YEAR(OrderDate))

,SUM(TotalDue) OVER(PARTITION BY 1)

FROM

#TestBasedOnYear

)

SELECT DISTINCT

TotalDueForTheCurrentYear

,OverAllTotalDue

FROM

Totals

WHERE

Yr = 2004

John

Not necessarily. Please will you...

You might get misleading results if you have constraints that span more than one column:

CREATE TABLE #john2 (col1 int, col2 int, col3 int)

ALTER TABLE #john2 ADD CONSTRAINT UQ_John2 UNIQUE (col1,col2)

ALTER...

bala.a (9/14/2012)

---

How it's possible to have more than one unique constraint on the same column? Obvoiusly, you should get an error, if I understand your question right....

Could you please provide...

I don't have a script that does exactly what you require, but you could try querying the INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE view.

John

Gail, thanks for pointing that out.

Shobha, have you considered using DBCC CHECKIDENT?

John