The index is scanned because it is retrieving all the rows in table B.

Regarding your question about if the index is useful or not, the proper response would be,...

Make sure the SQL Browser service is running at the time this error occures.

Hi thanks for the response,

But the distribution list is created in the domain, so it is visible from every other computer. I tested it from other computers and works correctly.

Hi I just wanted to show you that I finally got the answer I was looking for. Mr. Aaron Bertrand posted on this:

http://dba.stackexchange.com/questions/19527/capture-all-queries-that-use-hints

In summary this is the query...

Sean Lange (6/19/2012)

---

That is a bit vague in requirement but there are some things you can do. Are these queries pass through queries or stored procs? That will make a...

Thanks guys for the quick response.

These are queries not stored procedures.

Second I would like to capture both table hints and query hints.

have you try a ping to the database server?? does it works?

If you can connect from another PC different from the database server, then it could be a problem with the names resolution, please try conect to the instance with the...

You need to check the following things:

1) Is your SQL Browser running? Since you are accesing a named instance you need this service because normally named instances use dynamic ports,...

Hi,

As I told you, install a new instance of SQL Server Express in a new machine, once it is installed, run this command in the SSMS:

use model;

go

sp_helpfile;

go

This command will give...

I think the error message is clear your model database is corrupted, I would recommend a simple solution for this, install a regluar SQL Server Express instance in another machine,...

Hi

Correct me if I am wrong but you want a key which is composed by three datatypes:

char(2) + date + smallint

If I was in your place I would just...

Hello,

First create the new filegroup

USE master

GO

ALTER DATABASE Test1

ADD FILEGROUP Test1FG1

GO

ALTER DATABASE Test1

ADD FILE

( NAME = test1dat3,

FILENAME = 'k:\SQL\database.NDF',

SIZE = 200GB,

FILEGROWTH = 10GB)

TO...

@Adiga you're the man, thank you so much for helpping me understand why I could not shrink my tempdb. I really apreciate your help.

Finally after running the...

I disconect every session apearing in the sp_who2 which had a conection to tempdb and did the shrink but still no luck.I also tried to do it by the SQL...