There's a new "Search" link above here, but below the Google search. Try that one.

Brian, we'd love to have more, and we miss your great information, but we completely understand you working on other projects.

You do what you can, and what your passion is....

We are pro-SQL Server, but not bigoted against other solutions. It's just that we often see procedural or OOP type solutions that don't perform well in SQL Server. SQL Server...

Wow, quite a response. While we might not consider ourselves musicians, seems like lots of us have a guitar or something we mess around with.

The maintenance plans have their own connection information inside. If you select trusted connections, it should be ok, and then you can run SQLAgent under an account and it will...

The 2008 memory should be like 2005 for standard edition, it's the OS limit.

Use the Enterprise Manager app to make the change to be sure that the correct permissions are assigned. Select the server, right click and choose properties. The security tab has...

It's the way the client is written. QA isn't designed to be interactive like Access.

If you ran the stored procedures to create the trace on the named instance, it will run there. If you start Profiler, you have the option to connect to a...

Collation can be by database, table, or even column. Script the tables out, looking for collation differences.

There's some good advice above, and documenting is #1.

document your concerns, get your IT director a copy and ask him to sign off. I'd also contact an HR person or...

Perhaps you could explain what the wrong results are?

Or you can use Dateadd() with other values (hour, minute, etc) and randomly add those to the beginning date.

I've worked with top notch coders, meaning they write great code that isn't buggy, runs well and fast, tests well.

And doesn't meet my needs.

Communication is key, and it's important that...

In sysindexes there's a GROUPID, which is hte filegroup ID, you can join that to sysfilegroups to get the name of the filegroup. Not sure you can get to the...