Joining the 2 tables into 1, you lose the data normalization that was done.

Do as you wish, it's your choice.

At some point, depending on what is done, you may lose...

jasona.work (1/3/2014)

---

Quiet around here the last couple days...

Are we trying to let Gails' posting catch up with the post count of this thread again, or did everyone take the couple...

Review the coursework, keeping in mind how much experience level they are looking for.

If you have dealt with SSAS in SSRS reports, that would be a good start.

And a bonus...

SharePoint should be able to secure this.

Although if the report is sensitive, I would think the raw data should probably be secured as well.

And you can secure folders within SSRS,...

MysteryJimbo (1/2/2014)

---

Here's a couple of articles for you to look into it.

http://bradmcgehee.com/2011/03/10/do-you-enable-lock-pages-in-memory/%5B/url%5D

https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/%5B/url%5D

In my case, the only reason this option wasn't enabled was based on a MS article at the time...

pujain (1/3/2014)

---

Thanks for your replies.

why I need this much of data : This is the requirement by Higher management for some analysis purpose, I know this much of data is...

Jim1234 (1/2/2014)

---

Hi Team,

We are designing a Staging layer to handle incremental load. I want to start with a simple scenario to design the staging.

In the source database There are two...

Atradius (1/2/2014)

---

@GregEdwards - there has been no movement of this database nor any change in AD. The database in question was created on that server. The older databases did come...

Also do not forget other applications that use your SQL server. You may have web applications for example that will also be impacted.

As mentioned earlier, some of this may not...

Re-reading your description, it sounds like the older db's work, so you should try to compare the SID for that group to the SID for the newer group.

Is it possible that the db was moved to this server?

Or you have had some AD domain changes / consolidation?

If the security was added under a different domain, the Group...

Thankful for the cold and white snow.

Sounds like a real mess not too far east.

Hope everyone is warm, safe, and has a great holiday.

Jeff Moden (12/21/2013)

---

We have a wonderful "on call" policy. Anyone and everyone can be called at any time.

The neat thing is that, in the 2 years I've been working...

Use BOL and see if searching...

Revenant (12/20/2013)

---

GilaMonster (12/20/2013)

---

Grant Fritchey (12/20/2013)

---

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of...