It's back: http://www.sqlservercentral.com/Forums/Topic1480523-83-1.aspx

Toreador (8/1/2013)

---

I can understand that. It's a shame therefore that the newsletter...

Ahh, sorry. I misread. didn't realize you needed the other filestream container. I was thinking you wanted it removed completely from the db.

I'll have to look at this more. I...

Take it. Should be easy, just think about how you can teach a beginner to get a plan they can send to someone for remote help (forum, email, etc.)

Bump, send me a disaster situation/solution you've dealt with. could be natural disaster, man made, test situation, or user error.

I'm not an expert in this area at all. Grant is much better.

That error looks like either a contract isn't set up properly, or it's trying to make a call...

DDL would be the table create. Here's a working example in T-SQL

use sandbox;

go

create table Test

( id int

, shipdate date

, shiptime time

)

;

go

insert Test select 1, '1/1/2013', '4:45pm';

go

select * from test

select

...

You have to remove the filestream column in the table. Or point it to a new filestream filegroup.

left outer joins don't necessarily lock the table. Would like to know where you read that, since it's wrong.

The outer joins often scan the whole table because you may end...

Geert Vanhove (8/1/2013)

---

If the issue is limited to one single table I'd check it's clustered key choice. Fragmentation is most often the results of page splits which are most often...

SSMS doesn't do this directly, but you can query sys.locks for information. You might start, however, by examining the execution plan and seeing if you have issues with your code.

Why...

http://www.solidq.com/sqj/Pages/Relational/Identifying-and-Solving-Sort-Warnings-Problems-in-SQL-Server.aspx

http://amihalj.wordpress.com/2011/12/07/sql-server-2012-detecting-sort-warnings-with-extended-events-sort_warning-event-part-2/

You have to provide more information. What are the data types of the source fields and DDL?

It might be as simple as concatenating the fields and converting to date time.

It's also entirely possible with your workload that you need the space. There is not set size for tempdb. You need what you need for your workload.

If it grows consistently...

glad it's working for you. Usually if you install with defaults, the firewall isn't too much of an issue, but it can be frustrating to get it working.