that's the expected behavior:

if you compare anything to null, the results are undefined...

so you either want to add a where clause like ...AND A.DATE IS NOT NULL AND B.DATE IS...

parameter sniffing maybe? have you isolated which proc slowing things down? does it have a default value for any of it's parameters? in my experience, it's the default values that...

i tried running the command over a linked server; basically i tried changing the last command to a 4 part command:

EXEC linkedservername.master..xp_regread 'HKEY_LOCAL_MACHINE', @inst, @inst1

got this error:

SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\SuperSocketNetLib\Tcp\\\\////TcpPort

Msg 7411,...

the BETWEEN oerator is what you want i think;

select * from sometable where invoice_date BETWEEN '01/01/2009' AND GETDATE()

you said how to select max date's each home , location and status.

like lynn said, all the tools are there...run this, test it, and drop the columns you don't need.

indexes become fragmented due to inserts.

say you have an index on "LastName".

if i insert someone whose lastname starts with "S", it will probably fragment the index, as it forces anew...

a GO statement ends your procedure, and runs the next command; you've pasted commands INCLUDING the "GO" which is not what you want.

this is a better format:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

just a simple grouping is what i would use;

note how i put your data into CREATE and INSERT INTO so that others could use it as sample data? that's a...

it sounds like a network issue...maybe DNS/WINS?

at the end, it says the IP is 165.193.92.4. is that an IP Address on your network?

does your connection string use the name of...

if someone is on your network, they could put in a packet sniffer, and copy packets back and forth from a server to any machine. with some work, they could...

the rule of thimb I've heard around SSC is table variable is fine for 1000 rows or less, more than that it's recommended to use a temp table, and explicitly...

i like Florians idea; I'd suggest something like he says, showing top 500 or something,and then a message like "171,432 records match this criteria...click next to review the next 500"

well, bandwidth and local machines' capacity is going to be the limiting problems...download 10 million records locally, manipulate them in local client side memory, them send back changes to the...

that depends on the assignment your teacher gave you right?

the easiest is to simply use the built in wizards from SSMS: right click...Tasks..Import/Export.

Other options are to use the SSIS todo...

sql server management studio has that ability built in(right click on database...Tasks...Generate Scripts,

Also since you can sp_helptext any proc/view/function, you could do something like this as well:

SET NOCOUNT ON...