SQL Server offers RLS/CLS - short for Row Level Security / Cell Level Security. As I understand it RLS/CLS offers similar funtionality of what is called Virtual Private Database in...

tripri (6/21/2010)

---

I got a database of 20gb . Now i want to perform ETL process on that database so as to copy that entire database into another server.Approximately how much...

jaiki987 (6/21/2010)1. Is there a better way to work this problem other then stored procedures and jobs.

2. Are there are scripts or white papers out there that have tried to...

Ask yourself these questions:

- Is the system up?

- Is the system available?

- Can users connect?

- Is workload consistent with baseline for this day at this time of the day?

- Are...

Johnathon Wilde (6/21/2010)

---

Thanks for the response! I know where you're going with that, in regards to why would you call a Refcursor from SSIS rather than just do a...

I do not have an example for SSIS and I'm having a hard time trying to imagine why a refcursor is needed in such scenario.

Let me show you how a...

I think showed relationship between IncidentTable and RoadUserTable is not correct or doesn't exist at all.

Please validate all relationships.

HTTP is a hypertext transfer protocol.

FTP is a file transfer protocol.

Doesn't show cardinality, sorry - can't read it yet 🙂

No matter how fast the network is it will always...

Would you mind in showing relationships? othewise it gets real hard to understand navigation.

I see, not a pure archival resource but an archival/reporting one. Fair enough.

500 Meg is not a huge volume of data to be moved in a daily basis - provided...

Is it a batch job?

I would check scheduler, look at what the job is executing.

Did developer say why he wants to archive in a different box?

Is the box local or remote?

How big is the pipe in between the...

1 - Add new column. Check "alter table add column" syntax.

2 - Write an update query to implement business logic.