When I was doing Access/SQL work I set up a passthrough query to SQL that ran my record aggregate stored procedure.

I then set up a cross-tab query that used the...

Are there any updates on this?

The article left off where you were about to upgrade an IIS/SQL box. Has this been done yet and what were the results?

He was...

We tend to keep our IIS Servers on separate boxes to SQL Server.

We remove PUBLIC permissions to virtually all the stored procedures in the MASTER database because by default any...

I wouldn't have put it at 3 points and yes and extent was/is 8 contigious pages in SQL.

When I moved from SQL6.5 through 7 to 2000 I must admit that...

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...