Stephane

The scan is scanning the whole index (the whole table in the case of a clustered index) whereas a seek goes straight to where it needs to go to find...

Terry

I don't have access to a SQL Server 2005 server at the moment, so forgive me if the syntax isn't quite correct.  Use a common table expression (CTE) something like...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=209497

Stephane

OK, that clears up the IP conversion algorithm.  I still don't think that your sample data from tbl_ip2countries and from #regions tally up with each other, but let's not worry...

Stephane

I still don't understand.  The sample data you gave shows ipFrom and ipTo having 8 digits, and ipFloat having 9.  So how can ipFloat ever be between ipFrom and ipTo? ...

Nita

Run this on a test server before you let it anywhere near production.  It assumes you already have a login called MyUser and that you want the related user name...

Stephane

Your syntax doesn't look quite right.  I don't see how your update statement can work.  How about this (not tested, obviously):

update r

set countryId = c.countryId

from #regions r join...

Nita

Make the user a member of the db_datareader and db_denydatawriter fixed server roles in the database.  If you are asking how to do this for all databases, you can generate...

When a new row is inserted, it will be put on a page according to its place in the clustered index.  If there is no room on the required page,...

Mike, Robert

Thanks for doing the BOL/KB searching for me.  I suppose the real point of my post was to have a little moan that, in this QoD (and quite a...

Yes.  Whether it's a DELETE FROM, DROP or TRUNCATE, it's not going to work if the table is referenced by a foreign key constraint.

Come to think of it, writing a...

I'm working on reinventing the wheel on this one... but using sysreferences instead of sysdepends.  Will post the script when I get it finished.

By the way, jmcgarvey's script will also...

The explanation doesn't explain the answer: it merely restates it.  Would the setter of the question care to go into a little more depth, please?

John

Raj

I think you said earlier that you'd tried with an index on that column and there was no improvement.  Please will you post an execution plan for when you have...

Manish

AWE is only needed for memory above 4GB.  I'm not sure what's causing SQL Server to get stuck at 2GB.  Do you have any other applications running on the server? ...