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

Taking a minimalist approach, SQL Server's Import and Export Wizard, which is accessible by right clicking on a database in SSMS, provides the option to save the process to a...

Even if you build what you believe to be the perfect BI application that presents every posible key preformance indicator, you can't actually expose it to end users without upper...

Right, a SSIS package is just an XML document, so...

Craig Farrell (1/18/2011)

Your department head and data integrity are miles above the average company I've worked in. That includes financial firms and healthcare providers. No I won't mention...

Craig Farrell (1/18/2011)

---

...

Without anyone usually having the holistic view of everything occuring with any piece of data, we're spiraling out of intelligent data access control. We need to find...

Any project where there is a need to analyze the data scientifically will typically have real scientists on staff on contract. I've worked on projects side by side with statisticians...