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

SQL and T-SQL code tends to be derivative, especially if it's a general purpose script intended to do something like return the name of all unused indexes. Not to diminish...

It shouldn't take 20+ seconds for SQL Server to compile an execution plan...

sqldba_icon (1/20/2011)

---

... I have a procedure when it is executed for the first time takes about 25 secs and 2 secs from there onwards. Now from the application side every...