Argh! The SQL code get messed up for AlphanumericOnly somehow (bring on the contribution preview button 😉 ).

The code is still good, it just looks odd at the...

I know about them...

Another way without variables.

SELECT

mean,

ss = SUM(POWER(measurement - mean,2)),

n,

stdDev = SQRT(SUM(POWER(measurement - mean,2)) / (n...

Bill

sqlfriends (5/16/2016)

---

Thanks,

The server will be a VM not physical. The host will be on SAN disks for data, log, backup drives.

I plan to put on a 8 core, but 16...

Sometimes XML questions get no love around here.

I am not great with the XML modify method (something I need to read up on and practice I guess) but here's...

Provided that the XML files are similar you can absolutely do this. If they're not you can still do this, its just more complicated. You would have to post some...

How do you know it's running out of memory and what is crashing? The server, just SQL? Do you have SharePoint and SQL running on the same box?

Just a couple...

Jeff Moden (5/14/2016)

---

Alan.B (5/13/2016)

---

Something I don't understand:

SELECT * FROM dbo.DelimitedSplit8K('xxx,d','');

Returns the whole string. This makes sense, the function found 0 occurrences of the delimiter.

SELECT * FROM dbo.DelimitedSplit8K(NULL,',');

Returns a NULL....

Eirikur Eiriksson (5/13/2016)

---

TheSQLGuru (5/11/2016)

---

Alan.B: You have escaped the primary performance problem of chewing through unnecessary rows of each month on the date dim table with the filtered index. Well done....

Lynn Pettis (5/13/2016)

---

Alan.B (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them...

Something I don't understand:

SELECT * FROM dbo.DelimitedSplit8K('xxx,d','');

Returns the whole string. This makes sense, the function found 0 occurrences of the delimiter.

SELECT * FROM dbo.DelimitedSplit8K(NULL,',');

Returns a NULL. This makes sense,...

Lynn Pettis (5/13/2016)

---

Actually, yes. I have seen that a couple of script authors have posted scripts in multiple parts but it is difficult to find them since there are...

That's basically...

sqlfriends (5/13/2016)

---

We are implementing a project and need to setup a new SQL server.

The server probably will be used only for this project at least now.

It has database...