We use a cookie to store the info. Across my 4 devices, I never sign in, but I don't clear these cookies.

Tim Shay (8/1/2013)

---

Guitar. This season I hope to learn something outside the world of keys and indices. I've always found learning that doesn't seem to relate to work...

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...