succinct

My wife knows I do stuff with databases and am frustrated when she tells me of all the manual checks she does using a certain report because I can see...

Sean Lange (10/17/2013)

---

sqlblue (10/17/2013)

---

I have a stored procedure that needs to be called to update a table inside for a large date range (millions of records), but I wanted this...

It sounds like everyone is having entirely too much fun, except for the travel to get there, of course. I wish I would have taken the time to come.

sestell1 (10/15/2013)

---

Do you have a string literal being implicitly converted to a date?

Something like WHERE TABLE.Start_Date = '2013-10-15'?

If so, you might want to try changing it to WHERE TABLE.Start_Date =...

umesh.war.rao (10/15/2013)

---

Thank you for your reply... but this doesnot seem to be a permission/access issue... as I get the view structure.. but not the data.. it says (0 rows found).

I...

I would start by checking the Oracle permissions of the user being used to connect to Oracle from SQL. You're using all_objects, which is a view of all objects...

<sarcasm>

That's just beautiful. It even features a hard-coded connection string complete with the server, database, username and password. What could possibly go wrong? :w00t:

</sarcasm>

Yes, it's...

PiMané (10/14/2013)

---

Ed Wagner (10/14/2013)

---

My bet would be that if you created the index you specify ([Modulo], [Documento], [NumDoc], [Serie]) then both queries would use the same index. The optimizer...

Even though I'm not attending...

Gandalf (fictional)

My bet would be that if you created the index you specify ([Modulo], [Documento], [NumDoc], [Serie]) then both queries would use the same index. The optimizer picks the best...

I really hope MS never allows Excel to directly edit a SQL Server table - that could end up being a complete disaster for DBAs everywhere.

spending

SQL Server likes to cache stuff for performance, since disk I/O is usually an expensive part of an operation. Is your server under stress? Like was posted above,...