Jack Corbett (1/12/2012)

---

patrickmcginnis59 (1/12/2012)

---

For clarity, the original poster insisted the decision was not his, and the original replier suggested "select * from tablethatdoesnotexist" before changing gears to criticise...

GilaMonster (1/12/2012)

---

patrickmcginnis59 (1/12/2012)

---

look at the reaction you got because you preferred "raiserror" for instance, one fellow flat out called you "wrong" and pretty much rejected you on a personal basis...

DeanORenO (1/11/2012)

---

you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster...

sami.sqldba (1/10/2012)

---

Hi All

I am new to merge statement so need your help in making it better understanding for my task.

I have set of data in a table1 and set of...

winston Smith (1/10/2012)

---

I have a database restored on two seperate servers. The data in the database on each server is identical.

On serverA, when i do select * from viewA, i...

Jeff Moden (1/10/2012)

Of course, you could also pre-process tables before they come anywhere near SQL Server but I've found that writing such code is a bit of a fright because...

make sure you check for an extra carriage return in your source text file (ie., extra line with no content).

jtrumbul (1/6/2012)

---

Hello All,

I have a question which may be simple to answer and i could be way over thinking this but the situation is as follows. I have a...

Markus (12/28/2011)

---

Clustered index scan 100% on both on the primary Key. For simplification I am now simply running a select * from xtable... nothing complicated just a simple...

TheSQLGuru (12/30/2011)

---

I would try dropping off the PK from the table variable (note you do NOT have a temporary table here - it is a table var with many things...

oskaroh (12/30/2011)

---

sometimes the expressions are really big (well not so but big enough for the one line space there).

Is there a way to include an expression created in other...

I'm betting max_queue_readers needs to be a constant. I've run across a couple of cases that T-SQL doesn't like variables in certain statements. Try a constant instead of a variable?

patrickmcginnis59 (12/29/2011)

---

GSquared (12/29/2011)

---

patrickmcginnis59 (12/29/2011)

---

Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should...

GSquared (12/29/2011)

---

patrickmcginnis59 (12/29/2011)

---

Brian.cs (12/29/2011)

---

RCSI really puts SQL Server running in a similar mode to what Oracle does by default, which is really what all robust modern RDBMS platforms should support....

reminds me of this post:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/03/17/joe-celko-don-t-use-csv-xml-use-1-000-parameters-instead.aspx