jcrawf02 (10/19/2010)

---

CirquedeSQLeil (10/19/2010)

---

jcrawf02 (10/19/2010)

---

...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you...

Alvin Ramard (10/19/2010)

---

My input buffer filled up before I hit...

sturner (10/19/2010)

---

So you don't think I'm a grouch and since other did point a few of the more obvious problems, I will add that I see a lot of this...

It's basically the same query except for this:

DATEDIFF(yy, Clients1.DOB, GETDATE()) >= 30 AND DATEDIFF(yy, Clients1.DOB, GETDATE()) <= 34

which is buried deep in the middle of the thing.

So, instead of doing...

look into sp_change_users_login 'auto_fix', <loginname>, null after the reattach.

It'll take the users in the dabatase and re-associate them with the server login SIDs.

We're going to want to see expected results if we're going to try to figure this out for you, unfortunately. It's a little odd. Also, if you can...

It's because of the funkiness...

Ninja's_RGR'us (10/18/2010)

---

How would you guys react? I still have full access to all source codes and their backups. I have no intent to destroy there servers and yet...

You're looking for Unpivot.

A quick fix to the sample data:

CREATE TABLE [dbo].[#GblSecurityMain](

[EmployeeNumber] [int] NOT NULL,

...

chris.s.powell (10/18/2010)

---

Last question on the subject, as all of the information you have provided is extremely helpful, when our development team has a "once in a blue moon" bulk insert...

I... hesitate to tell YOU that it's okay to destroy YOUR backup files. However, I can help you figure out if it's right for you.

First, keep any trn files...

GilaMonster (10/18/2010)

---

Kalen Delaney did a talk for the 24 hours of PASS earlier this year...

Nope, and you won't want it to. You'll need that space the next time...

To add to what Gail said, yes, your T-Log can still grow. Simply you always need enough space for your largest transactions to occur, in whatever restore method you...

To go back to our earlier discussion on bad drivers in random places, apparently hit'n'runs are universal. Took my car out last weekend. Lowspeed, luckily, but it's dead,...