The Apress SQL Server books are pretty good. This is a good web site obviously. There is also sqlshare.com which has short how-to videos for SQL Server. ...

I'm not sure what else to call it when I reference my own blog. I feel kind of dirty doing it, but...

Steve Jones - Editor (10/9/2009)

---

Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at ask.sqlservercentral.com. Not my idea, and I'm not sure how...

Sorry, there is nothing else I can think of.

You need to define the parameters to allow blank values for string parameters otherwise they are considered required

Do you mean the WHERE clause in the cursor definition or the WHERE clause being set in the @cmd variable?

I would think that an email without any records would be...

In SSMS you can go to Tools -> Options -> Query Results and in the Results to Grids/Text there is an option to include the query in the result set.

This is just an informational message that is telling you that DBCC CHECKDB was run since the last SQL Server restart.

Well, without more details it's hard to give you an answer. Basically the Query Optimzer has decided that, given the available options, a clustered index scan is the fastest...

Dave has supplied the answer. Not to pimp my blog, but I recently blogged about this issue and the post may help you, http://wiseman-wiseguy.blogspot.com/2009/09/on-vs-where.html

I'm going to venture a guess here. You are seeing recovering as a the status every time a database is re-opened. When SQL Server starts up a database...

I've never run an in-place upgrade, but I would be very concerned if the master database was still in 8.0 compatibility mode. To me it sounds like the upgrade...

I really don't know anything about using Pervasive, but maybe this willl help with the connection string settings, http://ww1.pervasive.com/library/docs/PSQL/950/prog_gde/prog_gde-04-3.html.

You might want to try a simple .NET app or a Script...

There are a couple of issues. One is that by putting a filter on table B in the WHERE clause you essentially changing your LEFT OUTER JOIN to an...

Cool solution Mark. Not one I would have thought of. I'd have done something like this:

DECLARE @string VARCHAR(10)

SET @string = 'Sarat'

SELECT

CASE

...