Either nobody has had any complaints, nor needed someone to jump into an issue, or else everyone is just to darn busy to visit...

First question, are you doing a BULK INSERT into existing partitions or are you filling new unused partitions?

I really don't think anyone here is saying that there is only one way to do things. What works for one person may not work for another. This...

Sean Lange (4/16/2013)

---

Lynn Pettis (4/16/2013)

---

Sean Lange (4/16/2013)

---

I was wondering about concurrency when I...

Sean Lange (4/16/2013)

---

I was wondering about concurrency when I read your reply. I...

It is also possible to make the synonym unique between invocations of the proc if needed.

latingntlman (4/16/2013)

---

I need to pull records from a table and that would be pretty simple, however, the select statement needs to run as a sproc that passes a variable input...

Please, do not cross post as it will only fragment any responses you may receive.

Duplicate post, please post all responses here.

VegasL (4/15/2013)

---

Hello,

I have in select statement select t1.A/t1.B but get divide by zero error

when I used with isnull isnull(t1.A/t1.B,'-')

I get error Error...

erikd (4/15/2013)

---

dhananjay.nagarkar (4/14/2013)

---

Sure I would love to share-

Here's what I did-

created 3 temp tables with the filelds I need for each with same order, data type.

then UNION the 3...

dob111283 (4/12/2013)

---

This may be a stupid question but everytime I make a new command or query with T-SQL, do I have to open up a new query window or can...

The best I can provide is based on when I was setting up database mirroring. First, iirc, you need to select a port number above 1024, and I thought...

The difference could come down to indexes available. I'd probable go with option 1 rather than optiion 2.

Not true, using advanced options you...

Sean Lange (4/15/2013)

---

erikd (4/15/2013)

---

Hi,

Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to find a resource that just lists them all out, but...