My bad, the suggestion was for general ETL operations (Large one).

Forgot that it's hekaton.

Execute EXEC sp_spaceused towards the database, the reserved size shows the exact size of the database (Even the backup size for the database)

Kindly check what permissions/access you have given to the public role

Jack Corbett (8/26/2013)

---

Sean Lange (8/26/2013)

---

I would recommend breaking this into batches of 10k rows or so. A single insert with 13 million rows is going to kill your...

My recommendations:

1. Change the default value for max memory in SQL Server.

2. Leave appropriate memory for the OS too.

3. Check if there is memory presssure for SQL Server (If...

List to do according to priority. (foremost imortant things)

1. Make sure any kind of MONITORING is in place. (If not buy it by discussing it with your manager)

2. Make sure...

Ray M (10/4/2012)

---

Remove the < 6 from the where clause,

Then use the case statement to create the new derived columns you need.

Try it and get as far as you can,...

Ray M (10/4/2012)

---

Remove the < 6 from the where clause,

Then use the case statement to create the new derived columns you need.

Try it and get as far as you can,...

I think you will have to consider what else is going on the server when the query is giving late response.

run a trace on the instance for some hours to...

Can you post the script you are using to backup the database?

John Mitchell-245523 (10/4/2012)

---

It might help you to understand what's going on if you run the following just before selecting from the view:

SELECT SUSER_NAME()

SELECT USER_NAME()

It doesn't matter whether you're a sysadmin,...

Lowell (10/3/2012)

---

As you are...

my findings

1. when i execute the select statement in the view without the where clause it gives the results but more than the actual results it should give(naturally), not the...

No we dont use bespoke application.

TRUTH: I really didn't know what a bespoke application is, but i surely checked it...

MysteryJimbo (10/3/2012)

---

I apologize. I misread the original post that suggested there was an issue with permissions.

Data is not restricted on a permission basis. Either you can read the...