SELECT * FROM sysobjects WHERE xtype='P' OR xtype = 'S' OR xtype = 'U'

  |--Compute Scalar(<Removed for brevity> )

       |--Clustered Index Scan(OBJECT: ([master].[dbo].[sysobjects].[sysobjects]), WHERE: (([sysobjects].[xtype]='P' OR [sysobjects].[xtype]='S') OR [sysobjects].[xtype]='U'))

No difference. the query plans for the two are identical. In fact, checking the query plan, the query parser expanded the second out into ORs.

I tried these two

SELECT

That's brilliant. Thanks. I didn't think of looking there.

Can you read those from T-SQL? CLR?

Company I work for doesn't provide laptops. We all work on desktop machines.

I bought my own laptop, and while I do sometimes do work on it, it is my machine...

Sorry, for some reason I read that as Will Not.

I thought of that, and it's certainly an option. I'm hoping for a quicker way.

With login failures and backup logs and the like, my error logs often reach a couple...

The too many rows would be the big one. I can't offhand think of another reason.

Say the NC is on MyDate and returns 100 rows. That means over 100 random...

Count(*) returns the number of rows

Count(<column&gt returns the number of non-null values in that column.

In your case,

 select count(age) from dependent where age is...

Sorry, I don't fully understand your schema, or how stuff relates to each other.

If you invoice someone for 1000, what gets added to what table?

If the customer then pays...

The data corruption forum is probably a better place for this than the forum on administration of notification services. That said....

DBCC returns a statement at the bottom stating the minimum...

According to books Online (2005)

The Scan:Started event class occurs when a table or index scan is started.

The Scan:Stopped event class occurs when a table or index scan stops.

I've used them...

Logical fragemntation of 50% is bad, but it's not too bad, especially if it's a GUID cluster. I've had one up at 99.98%. The extent fragentation is worse. I do't...

December is financial year end for us, so no leave and on call for period 14 dec - 8 Jan for the DBA tem. Pity cause it's wonderful weather here.

Still,...

No need to move the pk, just get the clustered index onto another column. By preference (mine), static, ever increasing, narrow (esp if you have lots of NC indexes), unique.

You...