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...

"Where are the doughnuts? We used to always have doughnuts on Friday morning."

:rolleyes:

http://www.sqlservercentral.com/Forums/Topic944353-263-1.aspx

Developing T-SQL is like gourmet cooking; you accumulate recipes and techniques over the years; adopt from books and the experts on TV, and then improvise in your own kitchen. If...

As others have already pointed out, your current table design won't allow you to reliably query only those rows inserted as of a specific date. For what it's worth, just...