Revenant (5/3/2011)

---

Eric M Russell (5/3/2011)

---

Steve Jones - SSC Editor (5/3/2011)

---

Eric M Russell (5/3/2011)

---

It is possible for a database application (not using AI but just basic SQL ranking, fuzzy indexes, and...

Steve Jones - SSC Editor (5/3/2011)

---

Eric M Russell (5/3/2011)

---

It is possible for a database application (not using AI but just basic SQL ranking, fuzzy indexes, and reference tables) to return...

paul.knibbs (5/3/2011)

---

The public perception of computer systems is that they are mindless robots who interpret commands from operators literally and then follow through with them relentlessly, even when the operator...

It's the kind of error an operator could makes as a wrong choice on a menu or the entry of the name of the last network worked on instead of...

maverickza (4/21/2011)

---

Hi,

I want learn SQL server but want to do it self study - company I work for don't want to send me on a course.

What is the best...

Revenant (4/29/2011)

---

Eric M Russell (4/29/2011)

---

geert.bens (4/29/2011)

---

I would like to see developpers and DBA's in thought of building a house. the developper is the constructor, the DBA responsible for the fundations...

SQL Server routinely creates temporary "index" structures in memory or tempdb all the time, like during a hash join on large tables.

Staging tables and temporary indexes are common in scenarios...

geert.bens (4/29/2011)

---

I would like to see developpers and DBA's in thought of building a house.

the developper is the constructor, the DBA responsible for the fundations and construction plan

if both only...

blandry (4/28/2011)

---

I have never accepted this chasm. Even today I argue regularly that any DBA is not a DBA unless they understand code as well as database administration. ...

Recently I found a post where a developer was struggling with a variety of problems: design, backups, and more. It was obvious this person was overwhelmed and when someone suggested...

This sounds like a problem that could perhaps be better solved by ranking rather than by grouping. The example below is abstract and doesn't match your table structure, but you...

Fortunately in IT we don't have many occupational hazzards (so long as we use a laptop pad and stretch out leggs every half hour). However, balancing our screen time and...

sturner (4/21/2011)

---

An issue regarding the extensive use of software/firmware and intercommunication in new cars is not only that of security, but of survivability.

Systems subjected to EMP or high level of...

The issue with truncation of leading zeros is due to the Excel column being formatted as numeric. When using Excel to exchange data with SQL Server, it's best to format...

It could have been worse; at least they didn't lose your luggage or subject you to a strip search.

😀