Also SCOPE_IDENTITY() which works more like we'd expect @@IDENTITY to. These options are available as of SQL2K. They aren't in SQL 7.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

Exporting to text and then building a short script using regular expressions is perfect for something like this. Pick your favorite scripting language. Perl has excellent regexp support. VBScript does...

Bill, what type of box are you buying? How many drive bays?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

From an article I wrote:

Tables Without Indexing

Tables without indexing are a concern for obvious reasons. One of the things to remember is that primary keys are instituted with indexes,...

You're doing B2B? Or do you need it to service a web site?

Some general thoughts:

(1) Use SSL (you can create your own cert and any who want to connect will...

Pretty much, yes.

NET_ADDRESS, as you've probably discovered, corresponds to the MAC address of the connecting client. The second action really bites because it means you have to keep up with...

The more objects you are capturing, the greater the overall load. Also, since you are capturing remotely, remember that your server is having to transmit that information to the client....

Up to 2GB you don't need to do anything. Once you pass 2GB, then you have things to configure. NT and 2000 will allocate up to 2GB of RAM to...

If the memory is set to dynamic, you should't have to to do anything for up to 2GB. If you've set a maximum on your memory within SQL Server, you'll...

It could potentially be that the server has so much activity it's not able to take the snapshot. We saw this problem when we were trying to diagnose "freezes" on...

What error are you getting? Are you getting server not found or are you getting a login failure error?

If the login failure error and you're trying to use Windows authentication...

Yes. The next couple of articles should talk about doing just that.

Most of the scripts I have written where I work use Win32:LE...

I know with SQL Server Notification Services and with Win2K SP3 we weren't supposed to discuss anything. I was thinking the same rules apply for the SQL Server service packs.

K....

Two commands:

DBCC FREEPROCCACHE

This one clears the execution plan cache. Even ad-hoc queries are in there, so clear it.

DBCC DROPCLEANBUFFERS

This one clears the memory cache of data.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

Sure. The book is called Beginning Perl for Bioinformatics and its available from O'Reilly. Here's the O'Reilly page on it:

http://www.oreilly.com/catalog/begperlbio/

The first sentence of the description reads: