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

Nice to see someone playing devil's advocate.

I'm not sure that I totally agree although I have very limited XML exposure.

My understanding is that the rules about what an XML file...

Actually, I quite like the idea behind the multiple clipboard thing, it is just the implementation that is crap!

It would be nice to be able to save one of these...

quote:

---

I generally put in some text that allows me to get past the assistants balloon help and into the actual help file...

I think the problem with Access is that it is an end-user database and as such has to be as simple and as forgiving as possible.

This is fine, but how...