That's the problem with relying on system-generated names for constraints, such as primary keys.

You would think Microsoft would know better.

USE tempdb;

GO

CREATE TABLE #SystemGenerated

...

This White Paper from Microsoft will help you focus you efforts in the right place:

http://msdn.microsoft.com/en-us/library/cc966413.aspx

Start with the basics: http://msdn.microsoft.com/en-us/library/cc966413.aspx

If you can show that it is not a SQL Server problem, enlist help from your hardware specialist.

Beware the fact that user_lookups are always counted against the clustered index. Non-clustered indexes always have a zero for that counter.

As far as...

Precisely, which counters are you monitoring?

Tom,

Please read, run, and make sure you understand each point in this demonstration script:

Setup:

IF OBJECT_ID(N'tempdb..#TableX', N'U')

IS NOT...

Setup:

DROP TABLE #Data;

GO

CREATE TABLE #Data

(

mem_id ...

shawndidy (3/13/2010)

---

I totally apologize for the troubles, as it is i'm still mastering T/SQL programming. I just executed the questionSelector procedure and i got this error:

Msg 8146, Level 16, State...

Just in case ALZDBA left any room for ambiguity: do not store or process dates as strings in SQL Server. Use one of the date/time data types. Always.

😛

Voted 'no'.

The separation of CREATE/ALTER does more good than harm, in my experience.

SQL Server != Oracle

Paul

I have corrected the missing columns, spelling errors, and ordering of your script.

I do wish you had tested it before submitting - I do not like wasting my time.

Nevertheless, once...

* snigger *

See the entry for root here

As far as I can see, the previously posted code doesn't meet the requirement to select a minimum of three rows, a maximum of 25, and 10% of the group...

gilbert delarosa (3/12/2010)

---

Each of my clients has its own database with all of the same obects. I often have to query data for all clients for internal reports. I have...

The fact of the matter is that there is no perfectly sound way to identify 'system' databases.

The best you can do is to take a combination of the advice so...