SQLRNNR (8/2/2013)

---

Brandie Tarvin (8/2/2013)

---

How many people (besides Jeff and myself) have written SQL Spackle articles?

How many SQL Spackle articles are there?

Yes, I have a reason for asking. But I want...

Nice, and thanks for the update.

I'm not closing this thread, but I'll be responding less here.

I plan to write some pieces across the next week or so that will address specific design changes and...

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/