SimonH (4/30/2015)

---

I've recently started a new position and our production box

Contains a procedure that uses 30 + temp tables. I'm currently not in a position to change this as it's...

Try this:

set dateformat mdy;

SELECT...

Michael Meierruth (4/30/2015)

---

Eric M Russell (4/30/2015)

---

99999999 is always assumed by SQL and most programming languages to be...

At least they rebuild indexes after completing the shrink database. Actually, I don't agree. As DBAs we should be monitoring our databases and ensuring that they have adequate...

And can you have some down time to complete the deletion of data?

planetmatt (4/29/2015)

---

I'm using the below SQL to delete about 110million rows in batches of 100,000

It's working fine in that if I stop the script, everything up to that point stays...

This help?

http://stackoverflow.com/questions/14727900/how-to-fix-exit-code-issue-while-using-winscp-for-sftp-from-within-ssis-package

mistylove98 (4/28/2015)

---

I have to write a delete statement that deletes all customers that have not put in an order I must use a subquery in the exist operator can someone...

Eric Prévost (4/28/2015)

---

It's better to stay away from database owner chaining.

In your situation, you can grant permissions on underlying objects in other database to users executing the procedure, or you...

webrunner (4/28/2015)

---

Ah thanks for your answers.

Yes, in this case the code does access different databases. I guess that is the issue. Do you have some general article or web references...

Lynn Pettis (4/28/2015)

---

SQLRNNR (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had been posted on the forum thread....

webrunner (4/28/2015)

---

Hello experts,

I need help with some confusion I have over stored procedures. I have heard that it is a best practice to use stored procedures to encapsulate some SQL...

Making the url easier to follow:

http://dbaspot.com/ms-sqlserver/371877-how-allow-apostrophes-string-parameters.html

What part is wrong?

The data from the initial query we worked on or from the final query?

Did you ever post expected results based on the 3 lines of sample data...

SQLRNNR (4/28/2015)

---

Lynn Pettis (4/28/2015)

---

The OP just PMed me with all the info that had been posted on the forum thread. Apparently...