GilaMonster (1/29/2013)

---

I went through all of the ones I saw yesterday, his post is not relevant, the over-sized plan cache problem on SQL 2005 RTM and SP1 is not going...

Hugo Kornelis (1/29/2013)

---

wolfkillj (1/29/2013)

---

(And yes, I know I spelled DR0P TABLE with a zero instead of an "O". In posting on this forum, I have discovered the my employer seems...

CapnHector (1/28/2013)

---

Eugene Elutin (1/28/2013)

---

purushottam2 (1/28/2013)

---

Yes, Because in one of my query, i am joining with 3 tables. And table 1 have the 1 million record, 2 Lakh and table3 have...

If I were...

HowardW (1/29/2013)

---

wolfkillj (1/29/2013)

---

I noticed that there's a user who seems to be digging up very old threads (all on the same topic with approximately the same question - inquiries about...

siggemannen (1/28/2013)

---

Can SQL Server guarantee that if I issue a command like:

INSERT INTO T(...)

SELECT t.a, t.b, 1

FROM sometable t

UNION

SELECT -t.a, t.b, 1

FROM sometable t

, both "sides" of union will retrieve...

I noticed that there's a user who seems to be digging up very old threads (all on the same topic with approximately the same question - inquiries about "sleeping" connections)...

mpradeep23 (1/27/2013)

---

Hi

Can i store the database creation script in a table call the script in stored procedure to create new database with tables and stored procedure

can any one...

Good question. I liked that it required investigation or at least consideration of several matters: the operation of the CHECK constraint, the significance of the primary key declaration (especially that...

Alex koranteng (1/27/2013)

---

Thanks for the pointer. The code is the same. The data for the joins in the two environments are slightly different, because the test server data is a...

L' Eomot Inversé (1/25/2013)

---

wolfkillj (1/25/2013)

---

Sean Pearce (1/24/2013)

---

I am getting myself confused with some simple maths :crazy:

Answer 1

Coalesce can take more than two parameters, and IsNULL takes exactly two parameters

97%

Answer 5

Coalesce...

David Ziffer (1/24/2013)

---

<snipped>

So why does Express Edition install a version of BIDS that does not work no matter what you add to it, and which requires removal and replacement? I...

Sean Pearce (1/24/2013)

---

I am getting myself confused with some simple maths :crazy:

Answer 1

Coalesce can take more than two parameters, and IsNULL takes exactly two parameters

97%

Answer 5

Coalesce takes exactly two parameters,...

sarwaanmca (1/23/2013)

---

I Created a one Procedure ..its given Below...

create procedure [dbo].[USP_Reliance_Master_Upload]

as

begin

declare @dt datetime , @Mnth varchar(10)

BEGIN TRY

SELECT ...

jasona.work (1/24/2013)

---

This is my new mop. George, my friend, he gave me this mop. This is a pretty good mop. It's not as good as my first mop. I miss...