Udall

Happy thanksgiving everyone.

I knew it was a "humour" question, so didn't read it properly at first -- didn't look at the code) so didn't notice the dateadd....

Stewart "Arturius" Campbell (11/27/2013)

---

Interesting one, thanks Mike

Had to research, even found Kimberly Tripp's blogs on this topic (8 Steps to better Transaction Log throughput

[/url] and Transaction Log VLFs – too...

In SQL 2012 the fractions are between 0 and 9 in Latin1_General_CI_AS but not in SQL_Latin1_General_CP1_CI_AS. It's the same in SQL 2008 R2, and unless my memory is broken...

Good question. I learnt something.

I picked 4, which was wrong, because I have neve seen fewer than 4. I guess I've never worked with a database that started...

ScottPletcher (11/26/2013)

---

I don't think...

Luis Cazares (11/26/2013)

---

He's trying to count the events with Recordtype = 'promo' that have a corresponding event with Recordtype = 'event'. I don't know why, that's up to your needs.

The...

Any or all of those things (except just stay a DBA for ever). I don't believe in specialising too much. Once a DBA has become a capable generalist...

David.Poole (10/31/2013)

---

Coming back to this after 4 years the observations I would make is that the world has taken a different path.

People needed a low cost alternative to Oracle, SQL...

Presumably each of these things turns up more than once, otherwise there are 300+columns in a table which only has one row. But you haven't yet defined what...

Stick

Rune Bivrin (11/26/2013)

---

If SOUNDEX() as implemented in SQL Server was remotely useful outside of English-speaking countries I might care one way or the other. As it stands it's one of...

Good question, and nice explanation.

Too many people still fall for the claims that Soundex is a phonetic algorithm for indexing by sound and that it's based on American English pronunciation,...

Maybe we're just playing at snakes. DBA speak with forked tongue and write with...

Revenant (11/25/2013)

---

Hugo Kornelis (11/19/2013)

---

The question did provide me with an opportunity to research. I am normally quite uninterested in these options - have not used them ever, and know that...