Donalith (5/18/2011)

---

Ok, someone tell me there's a faster way to do this. I have a table with 37k string fields (open ended question responses) and I'm trying to extract words...

I wouldn't usually start...

Hey Gary, a nice lab and an excellent approach to simplifying the concepts of a messaging queue. The devil is in the details in SB, but it's still an...

Bah, no worries...

RyderD (5/17/2011)

---

And a full database restore in the middle of a development cycle wouldn't throw things off? I can't tell you how many times I've lost users, roles &...

RyderD (5/17/2011)

---

I'm not actually disagreeing that developers who are supporting production enviornments need access to a version of production data. Of course they do - there, in fact, is...

RyderD (5/17/2011)

---

I realize I don't post here, and perhaps I'm missing the point. But how can people reconcile this type of response (which I don't disagree with AT ALL)...

I'm kind of a catch-22 when it comes to this, because I can get pretty dang paranoid about my production systems. Depends on the system, though. Some I...

Drammy,

From this:

1, Extraction of everything from source database into text files.

2, Analysis of text files, reading metadata -> creation of a .sql file containing T-SQL to drop and recreate the...

You're correct, the second step is unnecessary.

See this article: http://msdn.microsoft.com/en-us/library/ms187317.aspx, in particular in the remarks section for when you have to manually start a population. If WITH NO POPULATION...

The advertising above has been reported. Now, to the OP's question...

Earl Downs (5/16/2011)

---

Hello, I'm trying to know how to check if my database triggers and other objects are...

Trey Staker (5/16/2011)

---

Craig Farrell (5/16/2011)

---

Trey Staker (5/16/2011)

---

All the US cities are in warm climates (usually) so I'd probably go to any of them. I wanted to go to Orlando...

I have a few other questions about what you're dealing with here, and to clarify I understand your process.

Let's start with the staging table. It's a bulk drop of...

Trey Staker (5/16/2011)

---

All the US cities are in warm climates (usually) so I'd probably go to any of them. I wanted to go to Orlando but the timing wasn't...

Rahul The Dba (5/13/2011)

---

Hi nice article, can you help me.....???

I have done DBA cerification in SQL 2005 in 2009, my bachelor degree will be done by june of this year,...