I tend to prefer fewer indexes, but with composites and includes, but as Gail and Grant mentioned, those have to be based on your queries. There's no way to decide...

I'd keep things in the db. Use a synonym or three part naming to do this and execute it in the database. Make sure you include error handling if the...

Lynn Pettis (4/2/2014)

---

The other part of this is that you are trying to update 5 million rows of data at once. Remember that SQL Server needs to write all...

The big issues are keyword clashes. Something allowed in SQL Server 2000 (v8) might be disallowed in 2008. I think the outer joins, with non ANSI syntax might be an...

Grant Fritchey (4/1/2014)

---

GilaMonster (4/1/2014)

---

I don't have too much beef with the language, but the way the fans talk about it, you'd think it was about to end poverty and bring...

Ray Herring (4/2/2014)

---

While the April Fool's joke is great the sentiment behind it is very serious. IMHO Microsoft is driving away SMB in a number of ways.

In my case...

Nope

Feel free and submit it on the site.

That would be good, but a basic, simple, 2 pager on importing separately would be good.

Skiing today, but enjoy.

I decided I can't communicate with those two and I'll stay...

Just read "The Martian" by Andy Weir. Highly recommended

humbleDBA (4/1/2014)

---

GilaMonster (4/1/2014)

---

Steve isn't suggesting running the traces via the GUI. He's suggesting using the GUI to create a server-side trace script and then running that. It's easier than trying...

GoofyGuy (3/31/2014)

---

I suppose we simply have different ways of looking at the issue, Steve, although I'm glad we both think action of some kind is needed.

Another participant noted that delineating...

I'd hope so, but regardless of their vocality, I think there are entirely...

djackson 22568 (3/31/2014)

---

Special interest groups do not cause prejudiced people to wake up and realize they are wrong. They do cause non-prejudiced people outside the group to feel like...