GSquared (11/14/2011)

---

Greg Charles (11/14/2011)

---

It's too bad nobody referenced BOL for this quote:

"If a SELECT is used in an application or script that has logic dependent on the number of...

Alexander Suprun (11/10/2011)

---

raotor (11/3/2011)

---

Hello,

I am new to SQL and am slowly llearning, so please forgive me if I ask a dumb question.

I was reading through a couple of articles on...

raotor (11/3/2011)

---

Hello,

I am new to SQL and am slowly llearning, so please forgive me if I ask a dumb question.

I was reading through a couple of articles on the web...

The full error message you are getting is this one:

Msg 208, Level 16, State 1, Procedure test_delete, Line 6

Invalid object name 'table1'.

Msg...

Kwisatz78 (11/8/2011)

---

Its quite complicated, as the view its querying also performs a mass of min and avg functions to bring back the mins and avgs per batch_id.

If I was to...

Andy Reilly (11/8/2011)

---

Sorry guys / girls,

I was going to post execution plans etc - But there's something odd going on with our dev server at the mo - so not...

Ninja's_RGR'us (11/8/2011)

---

TheSQLGuru (11/8/2011)

---

Andy Reilly (11/7/2011)

---

Hi,

I have a query that is causing me problems. I restore the db run the sp and it takes 20+ seconds. I do nothing...

Brandie Tarvin (11/7/2011)

---

Alexander Suprun (11/4/2011)

---

Stefan Krzywicki (11/3/2011)

---

Brandie Tarvin (11/3/2011)

---

I forgot to mention something.

If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a...

Stefan Krzywicki (11/4/2011)

---

alexander.suprun (11/4/2011)

---

Stefan Krzywicki (11/3/2011)

---

Brandie Tarvin (11/3/2011)

---

I forgot to mention something.

If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data...

Stefan Krzywicki (11/3/2011)

---

Brandie Tarvin (11/3/2011)

---

I forgot to mention something.

If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow Task instead,...

amrinea (11/3/2011)

---

I can understand tempdb getting to be bigger if certain queries are running, etc. Usually I see that in terms of disk space, not in memory consumption. However, given...

Lynn Pettis (11/3/2011)

---

Remember, TempDB is used by all the databases, not just for temporary tables and table variables, but also for queries that require sorting (ORDER BY, DISTINCT, GROUP BY)....

dva2007 (11/3/2011)

---

this sentence clarified lot of things for me.

I always thought if it is big table then index seek would be faster. it is clear that for smaller table...

Just don't give any permissions to the tables. Force application to work using stored...

Ificator (10/30/2011)

---

I work on a product that utilizes a large number of databases to store user data. The data is partitioned across the databases at a user level, so we...