Er, yeah. typo. Sorry about that. Go with SAN.

NAS or SAN

Microsoft does not recommend the use of NAS for the performance problems you've cited. If you have the option, go with the NAS or a dedicated shared storage...

Then allow yourself to be a lungfish...

Introduction to the Dipnoi

Yup, I did say that you will go to scans. Any time you drop to an IS NULL you basically blow away the chance to use an index. That's one...

Do you mean SQL Lightspeed?

If the parameter coming in is null you only want to pull back records where the column has null entries? Or are you always looking to pull back records where...

Wikipedia: Lisp programming language

Does this mean LISP coming back in fashion to try and interpret the text?

You wouldn't run them in SQL Server. This can be done in SQL Server but it's much harder. You should put together a VBScript code which you'd run from the...

Your MSDE instance may not be setup to listen on any network libraries except shared memory, meaning only applications on the local server could. Look for a file called svrnetcn.exe...

Does the account your SQL Server runs under have rights to access the share. Keep in mind it's not using your account, it's using the SQL Server service account. If...

Have you tried ESX server? It is substantially better than VMWare's GSX server because it does not sit on top of an OS. We've actually been able to successfully use...

CramSession has some free study guides for this certification. You can find more at:

CramSession: MCDBA Certification

They aren't exactly tutorials, but they give you some idea of...

Is the SQL Server in production set up in Windows authentication mode or Mixed Mode security? If it's in Windows authentication mode, the client side connection string will always fail....

I'll piggy-back on Remi.

SQL Profiler is a tool that comes with SQL Server. If you have Enterprise Manager and Query Analyzer on your system, you likely have SQL Profiler as...