The danger in using acronymns like "OMG" and "TTYL" in your business correspondence is that your clients and coworkers will stop taking you seriously and laugh at you behind your...

Instead of calling the job explicitly, you could have a job that runs every five minutes or so, polls a table to see if any works needs to be done,...

In addition to expressions, you can reference user defined functions or non-deterministic functions for a column default.

However, a default can't reference other columns in the table, you would need...

Some these commonly used acronyms (like FUBAR) are vulgar. There is a potential for a text-to-speech or language translation software to sound out the root words literally, which is something...

rf44 (10/25/2012)

---

Eric M Russell (10/25/2012)

---

rf44 (10/25/2012)

---

Any idea why, when I try to use it, I receive a message:

Line 18 is:

CROSS...

rf44 (10/25/2012)

---

Any idea why, when I try to use it, I receive a message:

Line 18 is:

CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as b...

nevhancock (10/25/2012)

---

When I run this, the Name of the sp doesn't even exist in the db its matching to. The query text doesn't match the name either. All I was...

The DMV dm_exec_query_stats returns cached query plans, and in...

opc.three (10/23/2012)

---

Eric M Russell (10/23/2012)

---

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below,...

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below, each extended type (regular,...

Fraggle-805517 (10/19/2012)

---

...

Now, I don't know if this is really called parsing or replacing or something completely, different, but I have a hard time believing that someone hasn't done this before....

CptCrusty1 (10/19/2012)

---

Master Moden,

Absolutely she did... she rolled her eyes as dramatically as possible at the answers to her questions in that area.

Alas... She took a different offer. ...

CptCrusty1 (10/18/2012)

---

UPDATE!!!

Ok... We interviewed 2 candidates that seemed to have plenty of exp. C1 had 17 years of verifiable exp, checked his references, etc. Candidate 2 had FIVE...

SQLRNNR (10/17/2012)

---

I had never considered scheduling a block of time for interruptions by coworkers. Interesting concept. I'm not sure I could do that. But I agree that...

Sqlsavy (10/15/2012)

---

Hi all,

We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early...