@Eirikur Eiriksson

Just a quick question.

You used the MAX(wan)<>MIN(Wan) instead of COUNT(wan)>1

When I checked the estimated execution plan there is one less operator(compute scalar) in the first operation (MIN...

Can't tell exactly without the DDL as mentioned by Sean.

But as you said you need get all results when a user inputs a date and neet to search with Year...

Are you looking for a ping command? You need to enter the below command in command prompt aka cmd

press windows+R

type <cmd>

and enter this command

PING <servername>

also you can input the...

yup that worked , so this only works for a CS collation. Thanks helping Roland

Well the db is in CI collation. But now I changed the collation (Latin1_General_100_CS_AI) and checked but the same thing happened.

It is a bit old post but thought to give some direction. Please visit this link

http://technet.microsoft.com/en-us/library/cc775015%28WS.10%29.aspx

and this

http://stackoverflow.com/questions/7932000/sql-server-installation-errors-regarding-wmi-service

Not sure but give it a try.

I hope you are on the ORACLE platform seeing the DDL

FROM a SQL Server Point of view

If you created these table like these

CREATE TABLE eventhistory (

Event_id int not...

have you tested your linked server? if not (Goto->server objects->linked servers->right click yourlinkedserver and click test connection)

if the test is successfull you have access to your remote connection. if...

hei the books section is on the left not right!

And for books

Have you covered these

SQL server internals By kalen

SQL server MVP deep dives

SQL server administration by wrox publishers (any version)

There...

Since shrinking of database is not advised due to lot of fragmentation it creates. I hope the db is not shrinked , may be its online or in use. In...

I think the diagram is an object in the database . Need to backup and restore it to get access it

Thanks for the info ,I will give it a try to sp_whoisactive, but when you use sp_who2 I can only see some spid's in the

column so...

Good article for understanding deadlocks, I have some doubts regarding deadlock and blocking ,from your article I can understand that deadlock have circular dependency. But in our production server we...