Steve Jones - SSC Editor (12/14/2015)

---

Any of you see the Advent of Code?

http://adventofcode.com/

I've been solving them in Python and PoSh, practicing some code. Thought some of you might have fun...

#10? Really? Why not just ask...

Steve Jones - SSC Editor (12/9/2015)

---

A potential problem, but really you don't learn a lot about other environments. Developers aren't trying to be ops. They're trying to understand what requirements...

rodjkidd (12/11/2015)

---

ThomasRushton (12/10/2015)

---

Once again, SQL Bits has been announced and I have other commitments that week that I really can't get out of.

Pity they can't seem to stabilise the date...

Given that an asynchronous member of an availability group could be classed as eventually consistent, quite a few of us...

Me, for one.

Grant Fritchey (12/10/2015)

---

Grant Fritchey (12/10/2015)

---

That is beautiful. The sad thing would be the...

Once again, SQL Bits has been announced and I have other commitments that week that I really can't get out of.

Pity they can't seem to stabilise the date of this...

It is possible to schedule tasks to run without using the SQL Agent task....

Other free formatting websites are available - http://www.format-sql.com (from Red Gate), or http://www.sql-format.com (from DevArt)

Take your pick. But be consistent - they all have their own rules. Unlike...

Ed Wagner (11/23/2015)

---

I like that. Perhaps a more individualized approach would be to drop...

Yup. I'll see you in London on Friday. Looking forward to...

Assuming you have a table with columns such as PlayerName, Match, Score, then something like:

SELECT PlayerName,

SUM(CASE WHEN Score > 50 THEN 1 ELSE 0 END)...

Working backwards...

TLog backups - I've found in the past that it can help to increase the frequency of TLog backups during heavy index maintenance from, say, hourly to every minute.

As...

Are you saying that you only need to SELECT the data WHERE cAbsenceCode = 'P' OR cAbsenceCode= 'S'? and ORDER the results BY dtEnrollmentDate?

This appears to do what you want:

use tempdb

go

declare @testtable table (id int, value int, name char(4))

insert into @testtable values

(1, 10, 'test'), (2, 5, 'prod'), (3, 10, 'test'), (4, 4, 'test'),...