This was always something that annoyed me especially with tables that had many columns. It's a quick solution I could try. I'd be curious to see if I...

I was finally able to make it work but something tells me that it's not the correct way of doing it.

select @i = conversation_handle

from sys.conversation_endpoints ce

join (select conversation_id

from sys.conversation_endpoints

where conversation_group_id...

Got it! I had to change the SRID in my variable to match the one in the data.

set @geo = Geometry::STPolyFromText('Polygon((40.315260 -75.329130,40.308720 -75.320540,40.297590 -75.310240,40.264330 -75.357620,40.293660 -75.389210,40.327300 -75.372900,40.326910 -75.356590,40.315260 -75.329130))',4326)

In...

The only recommendation was to create one index. It had me create a covered index, given what we were trying to accomplish, it made sense. I probably wouldn't...

Aaron -- I tried the DTA and it recommended that I create another index. I tried it and it worked. I forget how useful the DTA is. ...

Haven't run the index tuning wizard yet.

The other 14 rows appear to be statistics for ad-hoc queries. I say that because the columns that are used are not something...

No. Just checked and there are only 5 indexes.

Zero rows. There are 19 rows when I remove the [first] is null section.

I should also add... There are about 11M rows in the table.

We're working on migrating to 2008 so these will definitely be of help to me....

Thanks for the prompt reply from my twitter request;) I'll check them out. I'm also thinking it's a statistics issue I just don't know why yet. I'm...

Thanks for a great post. Always great to read your stuff:)

I'm curious as to why you made this a table-valued function v. a scalar valued function? Does one...

Figured it out! The application was sending a begin trans but not commit. I changed some parameters in the application and it worked. So somewhere in the...

If the file has a patter like revenue_<<somesortoftimestamp>> you can use the revenue_*.txt pattern. This has always worked for me. And as long as the file name starts...