Steve Jones - SSC Editor (10/27/2010)

---

When I was going in IT, if you could spell VB, you COULD get a job. If you could get a few letters after your...

rootfixxxer (10/28/2010)

---

For example i have one section in the application where the users (workers) need to register hours for every working day, every user belong to a team, but the...

In an transactional database, I always default to at least 3rd normal form. If you want to create some denormalized summary or staging tables on the side for the purpose...

Specialization is for insects or career contractors. If someone wants to be secure in their job as an IT staff employee, then they have to know the business side as...

Of course,...

I still think that combining a logical identifier like client_id or store_id with another column containing either a date/time stamp or sequential integer makes more sense than stamping the network...

Looking at the Actual Execution Plan of the query may not tell you the internals of what the UDF is doing, but it should give you an idea of how...

chrisn-585491 (10/27/2010)

---

The sad part is that the folks at the top of the heap make...

I'm in the process of making myself a SQL Server / Oracle / Data Analyst / Business Analyst hybrid. I've had experience with all of the above over the years,...

lavien (10/26/2010)

---

I don't know why it has to rollback. The server have more than 30 process that the select statement using the full text catalog for some days(I had been...

Thomas-282729 (10/26/2010)

---

Eric Russell 13013 (10/26/2010)

---

I'm not intentionally trying to throw gasoline on the fire, but I'd just like to point out that, since a GUID is basically a combination of...

I'm not intentionally trying to throw gasoline on the fire, but I'd just like to point out that, since a GUID is basically a combination of various attributes like machine...

GSquared (10/26/2010)

---

Eric Russell 13013 (10/26/2010)

---

This why I keep saying that some type of identifier unique to each instance of the application or user, like client_id or cashregister_id, when combined with...

This why I keep saying that some type of identifier unique to each instance of the application or user, like client_id or cashregister_id, when combined with a sequential integer or...

Paul White NZ (10/25/2010)

---

NEWSEQUENTIALID calls the Windows API function UuidCreateSequential, which uses version 1 of...