Case Closed.

It turned out that when the Fan crashed, the tech asked me to apply an update for the system that was supposed to monitor the fan better. This...

After more research and investigating. I refreshed the statistics and the problem went away.

Thanks for the help.

Can you tell me how the statistics can get...

At my company, I was hired as a DBA and will retire as a DBA with no vertical or Horizontal moves inside the company. Other people were shocked I...

This is Microsoft's answer to the drunk coders problem.

http://xkcd.com/323/

Steve,

I posted earlier that for 1,000,000 records I ran my first solution at 1:30 and Jeff's solution at 10 seconds. I ran the GSquared "ultimate version" on a test...

OK Jeff, I did the original problem in about 4 minutes. I thought it was good, but then I read the first 1/3 of your article. I...

OK after racking my brain for about a week I figured out the problem. I did a DIR in dos only to discover that the trace program adds .trc...

I think you are seeing everything correct.

I have ran this statement

EXEC master.dbo.xp_cmdshell 'SET' and verified it is running as the user I thought it was.

I then ran this statement

SELECT *...

I am using a UNC Path because the examples all used them. I have also tried f:\trace files\sp_trace4122009.trc and F$\trace files\sp_trace4122009.trc to go directly to the file. The...

After looking at the order, add your comments, add a good article on the order of columns, give brain a tuneup and then look at problem upside down. ...

I have uploaded the two execution plans.

As for the Like with no wildcard, I am focusing on the index for the table tblenrollment and grabbed for testing purposes the part...

The Estimated I/O cost for the filtered index 20 is .003125

The Estimated I/O cost for the non-filtered index 2 is 1.83127

so the I/O is lower for the filtered index then...

It is using index 2 when running with out hints.

Here is the Query that I am running.

selecte.enrollid,

s.studentid,

s.firstname,

s.lastname,

s.dob,

s.stamp

from dbo.tblstudent s

inner join dbo.tblenrollment e on s.studentid = e.studentid

where e.campusid =...

SQL 2008 will run on windows server 2003 with no problems that I am aware of. I tested sql 2008 on windows 2003, but in Production I run...

You pick when you work.

have a private office at work.

Amiable Co-Workers: Everybody gets along well with everyone else, and everybody tries to help each other.

Salary: Enough to cover current expenses,...