jasona.work (10/25/2016)

---

Brandie Tarvin (10/25/2016)

---

jasona.work (10/25/2016)

---

So this ought to be fun...

Dev asked me to take a look at a view that isn't performing as well as it did on the system...

To be honest, the EAV structure has its place and if done correctly can be effective.

SQLDCH (10/20/2016)

---

You'll probably have a career week, like everyone else has against me. I'm top pointer getter in the league and 3-3.

Division matchups are on a hold for a...

Post the DDL (CREATE TABLE statement) for the tables, sample data (INSERT INTO statements) for the tables, expected results based on the sample data, and the current execution plan (as...

That long? 😀

Too easy.

Actually doing something like this to write an itvf. Can't capture a value to a variable in this case.

luismarinaray (10/24/2016)

---

Hi,

Please I need advise,

Environment: 2 node active/active

Situation: Both Nodes running ok with SQL Server 2008R2 10.50.1600.1, I proceed to upgrade to version SP3

10.60.6000.34, Node A sucessfully updated,...

maria.lindquist (10/24/2016)

---

I'm trying to convert a date to a string then grab parts of the string to make a value but it is not working correctly

Here is my code:

select externalId1

,...

Just an FYI for anyone interested.

Ed Wagner (10/21/2016)

---

TomThomson (10/21/2016)

---

David.Poole (10/17/2016)

---

I was aghast to find an old Clipper app still being maintained, although it didn't really need much maintaining. For next to no investment it...

camiloecheverry11 (10/20/2016)

---

I need a query where I can get the results from column qty hand, qty allocated and qty backordered.

My problem is that I have this query and...

SQLDCH (10/20/2016)

---

Bears v Packers tonight, get your lineups updated!!!

I'll try and get back later today for matchups. Only thing I can confirm now is that the SQL Bolts are...

Brandie Tarvin (10/20/2016)

---

jasona.work (10/20/2016)

---

Brandie Tarvin (10/20/2016)

---

I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB...

This: EXECUTE (@cmd)

executes the sql command contained in the string. That string is a BULK INSERT sql command that will insert the data from the file whose name is...