I use something similar when assigning rights to stored procedures, but without the cursor.

I know that this is only an example question but for the scenario listed

a) I would probably...

There are several sorts of test.

• Does the database do what it says it should do in the functional requirement spec.
• Bounds testing.  What happens if I try and enter silly values...

It is a BIT field test.

• BIT 1 = 1
• BIT 2 = 2
• BIT 3 = 4
• BIT 4 = 8
• BIT 5 = 16
• BIT 6 = 32
• BIT 7 = 64

The & means BIT...

I would be curious to know where Sybase ranks along side SQL Server, ORACLE, DB2 etc.

I have colleagues who are using Sybase on a particular project and because both SQL...

Could you give examples of the "notable exceptions"?

I don't like the idea of a huge and radical change to something as fundamental as the SQL.

Don't get me wrong, I'm enthusiastic about SQL2005 its just that the learning...

The thing with consultants is that they charge too much to be ignored.

If the boss hires a consultant and then ignores the consultants advice he may then have to justify...

I forgot to put in one particular class of user, and I can't think of a smart ass name for them other than "Git".

The Git insists that some obscure, hard...

The image says

The software that you are installing has not passed Windows Logo testing to verify its compatibility with this version of windows. Tell me why this is important.

This software...

Thanks Chris,

I've been tuning a stored procedure that itterates down a tree structure  to accumulate a list of ids within that structure and then returns the details associated with those...

I have been doing some experimenting with routines to traverse down a tree structure with temporary tables vs table variables.

God knows how but the rowcount thing resolved itself

Good primer!

If I have a stored procedure that does multiple tasks, is there a way of getting the  overall cost of the entire procedure or do I have to manually...

CREATE TABLE #MyTable(<column name> <column Type> , etc)

INSERT #MyTable(<fields>

exec master.dbo.xp_msver

I would second the motion to investigate the peaks.

I work on a large web CMS that has a complicated caching mechanism.  If I get the CMS caching right the database...

Yes, all stored procedures that I write have SET NOCOUNT ON immediately after the header block.

I haven't tried declaring variables as table types before so I'll give it a whirl.