You have to do

SET ROWOCOUNT 5

SELECT ...etc

Primitive

There is a hell of a lot that Sybase doesn't seem to do. DBCC SHOWCONTIG, DBCC DBREINDEX etc.

I've been trying to find out...

I got it wrong because I assumed that an extent was still 2K as it was in SQL 6.5. Yee Gods I hate it when a unit of measure...

Documentation is key if the supplier goes back on an agreement.

I had a situation where a product contains faults that need to be fixed. In my case it was...

I am just completing a 3 week task rescuing a bad database design on a poor performing application.

This has cost a 6 figure sum in terms of man power and...

quote:

---

Drop the primary key clustered index and create a new one on LAST_ORDER_DT

---

This...

I liked this one although CreateDBREINDEX.sql does not work.

It creates the temporary tables but doesn't populate them.

Your best bet is to set up a database role and grant permissions to that role.

Then make your users members of that role.

Don't be tempted to grant permissions to the...

Question of the Day for 30th February

Q. Why?

A. Because!

I think that this particular stored procedure facility would be best called "instancing".

I certainly wouldn't call it a versioning facility, primitive or otherwise.

I have experimented in the past with have...

I tend to keep a Word document that lists

• Arguments and types.
• Variables and types.
• Return values
• Fields retrieved (if any).
• Dependencies.

Included in this will be a detailed description of the stored procedure.

The stored...

quote:

---

What I think is always missed in the Windows/Anti-Windows debate is the large scale political and economic issues...recent announcement by China...

http://www.sqlservercentral.com/scripts/contributions/37.asp seems to work fine without a MAPI profile.

sp_makewebtask also makes a hamfisted but effective SMTP sending tool.

I can see the next generation of zealots coming over the hill. They're currently conducting the PS2/XBOX debate.

I seem to remember that there was a film about Steve Jobs...

Whilst you are experiencing the 100% datablocking try running sp_who, then running DBCC INPUTBUFFER(x) where x is one of the SPID's returned by sp_who.

I like the idea of this tool.

I tend to do a DBCC DBREINDEX on a regular basis, which is probably a bit OTT.

The only time I looked at a DBCC...