Jeff Moden (2/13/2014)

---

If the front-end...

That's the nature of T-SQL. T-SQL is a declarative language. It won't follow the instructions in the order that you write them, it will generate a plan to get the...

If you're updating all those rows, you should consider changing your scalar function to an inLine table-valued function. It will boost your performance.

If you need help on how to do...

With so little information given, you could check this article: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

You can still use DTS on 2008 if you want to have more time for migration. You can migrate DTS to SSIS in a phase 2.

You're still missing DDL for tables and indexes.

Things might speed up if you remove the ORDER BY and change your WHERE clause to

WHERE A.entitlement_function NOT LIKE '@@@%'

However, more improvements can...

SQL Guy 1 (2/12/2014)

---

It is very strange to hear that a DBA applies for bunkropcy. We are highly paid professionals who receive much more than the average value in...

CROSS APPLY works similar to an [INNER] JOIN and OUTER APPLY works similar to LEFT [OUTER] JOIN. Maybe that will help you to understand it better.

This article series by Paul...

You could use the query hint MAXDOP.

Check the reference: http://technet.microsoft.com/en-us/library/ms181714.aspx

Example F.

You're welcome.

The question now is, do you understand how does it work? You should do it before implementing it into production.

That's the difference of unique keys and primary keys. Primary keys will idenitfy a row within a table and they're essentially a preferred unique key. Unique keys will enforce uniqueness...

I'm not sure why would you want that. It seems like a weird requirement.

As you should know, triggers use 2 pseudo-tables (Inserted & Deleted) from which you need to get...

Craig-315134 (2/12/2014)

---

... out in the real world managers are often rewarded for being politically well-connected.

Sooner or later, the balance sheets catch up with them.

That's one of the more positive...

Why can't you sum a float column? float is a numeric data type and it can be used in SUM().

Here's what I used to test.

DECLARE @Appllication TABLE(

IDint,

Datedate,

Costfloat,

Fundingfloat

)

INSERT INTO @Appllication

VALUES

(1,'20140201', 10.52,...

I was about to write that a conversion was all you need as I...