Include adds data to the index so that a bookmark lookup is not needed (now a clustered index seek) to go back to the table for the data. Good for...

Never had much of a preference on mice, but let us know how it goes, Will.

Matt, what's an oodle? Is that a measure for 10TB 🙂

There should be no problems, although tinyint can store more values (2, 3, 4), so you possibly could have other data in there that your application doesn't deal with. So...

I pinged some people to see if there are any other solutions. I know I didn't renew our Lumigent maintenance at JD Edwards because we never used it. This is...

It does work, mostly for longer words. Like I type "SQLServerCentral" on the phone once and then it appears early in the list when I type "SQL"

The downside is that...

Yep, I think it is only 2000. That's what's on the site. It's also 32bit only.

Apparently there isn't much $$ in these products because people only want them when they...

Good article Jeff and it's nice to raise awareness about the issues here.

I think they days of phones just being phones are gone.

I've got features on the house phone that I don't even user or know how to use.

majorbloodneck, BTW, the blackspot...

I tend to agree with Wayne. I think it's not necessarily in their interest. They certainly don't want to deal with customers getting shut off and then calling, incurring a...

Working on that. I need some type of admin tool here to build the feed, but I'll see if I can get them separated out.

Steve

Nope, not with SQL only, but there are plenty of examples on how to load an image using programming languages.

I think you might be able to do this with scripting...

Bruce,

Enjoy it and feel free to send in some pictures if you like. Always looking for things to use in the editorial and happy to give you credit. Maybe we...

I'm not sure if there's a role in 2005, but I'm guessing you could give him SELECT rights on the DTS tables in MSDB, or even the whole database, and...

You'd have to query all fields.

select top 1 * from Mytable

where col1 = '05/12/2006'

select top 1 * from Mytable

where col2 = '05/12/2006'

etc.

If this is a datetime, only query...

Hopefully you know SQL Server 😛

Might watch this series: http://www.sqlservercentral.com/redirect/articles/61654/