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.

😀

Doctor Who 2 (4/15/2011)

You brought up an interesting point, Jack, and that's the number of recruiters contacting you, trying to fill jobs. A few years ago (I don't remember...

At my company, we are in year three of an enterprise wide project to consolidate all of the legacy applications, employees, and clients we acquired though acquisitions into a single...

As suggested earlier, it's probably another SQL Server instance, but if this continues to by a mystery, you can try using the Process Explorer utility to identify what process has...

Steve Jones - SSC Editor (4/12/2011)

---

Eric M Russell (4/12/2011)

---

It's just like those big concrete dividers that the department of transportation puts between the east and west bound lanes of an...

In any database that I have ownersip of, I typically grant application accounts authorization by adding them as members of a single role, and that role grants them only EXEC...

David.Poole (4/11/2011)

---

The intent of Version 0 is to show what can be achieved. A taster with a promise of jam tomorrow. My worry is that executive thinking is...