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

There are a lot of mistakes developers make regarding dates and data types; an entire presentation could cover this topic alone.

For example:

- Containing "date" values (ex: 3/10/09, 09/10/03, 3-10)...

If what you're wanting to do is BEGIN TRANSACTION, and then at some point have the option to ROLLBACK a unit of work while still having the option to COMMIT...

Try letting the Database Tuning Advisor analyze a few of these batches loads and see what it reccomends.