lcasamen (2/8/2011)

---

Thanks for the quick replies! I don't need to worry about gaps in sequences - Oracle loses values on rollback too, and I just need matching functionality. Long term...

Regarding job descriptions with too many technical requirements and resumes full of bogus experience, in many cases it's the result of a 3rd party recruiter acting as an intermediary and...

The forthcoming version of SQL Server, codenamed "Denali" will have a sequence type object that functions similar to Oracle's sequence. However, just like an identity, it can also result in...

I think it's common (not right but simply common) for IT people to fudge the truth on their resume or during job interviews. For example, someone who has a solid...

Mammals survived the Cretaceous asteriod impact because they were warm blooded, able to immediately adapt to both warm or cold environments. That, plus the fact that they were omnivores, feeding...

The org chart says I'm a database developer, but on a normal day I spend more time writing ad-hoc SQL queries and researching data issues than I do writing T-SQL...

Regarding the issue of data breaches, I'm not much concerned about outsourcing customer service as I would be oursourcing the hosting of applications or databases. If a customer service rep...

TheSQLGuru (1/28/2011)

---

The BEST way to manage LINKED SERVERS is to never use them at all! They do LOTS of unfortunate things. The way to avoid them is to...

sqldba_icon (1/28/2011)

Thanks Erick. So as per the first dmv in first block sum of data under "Total Mb's" should give the total amount of procedure Cache used from...

sqldba_icon (1/25/2011)

---

I am trying to findout is there a specific figure which would specify the % of cache being allocated from the memory. i did total of procedural cache on...

sqldba_icon (1/27/2011)

---

I do not have much knowledge of using SQLCLR or OPENQUERY other than linked servers. Mentioned below is one of my requirement can someone please provide me the actual...

TravisDBA (1/27/2011)

---

Michael Valentine Jones (1/26/2011)

---

"Small minds copy ideas but great minds steal them outright and make them their own."

Or something like that, can't remember exactly where I stole that...

Charles O'Halloran (1/27/2011)

---

"You can't trust stuff you download, no matter what the Open Source crowd says."

I'm pretty sure that is EXACTLY what the open source crowd does say. It's...

It's hard to stage a development or QA environment that mimics production. Often times an application or stored procedure may not work as expected only after reaching production because the...

In the database realm, I don't hear the phrase "It works on my machine but not in production", but it's not uncommon to hear "It works in QA but not...