This way is easier for everyone

http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/

I know it's been said that there are no magical solutions, but how about upgrading the server to use backup compression?

PS. Could you avoid sms language?

Scott D. Jacobson (8/14/2012)

---

Now if you really need the gig, you could always do as Luis suggests. Suck it up and take it. Try to be patient and...

Is REF_DOC a unique value? Or do you have it several times in ztb_Carrier_Delivery_Metrics?

As I see it, this is a problem with your data.

EDIT: Could you show us your code...

Scott Arendt (8/14/2012)

---

I just don't get the "shock" interview mentality. My boss did this to one of my co-workers. He brought him in for an interview and about half way...

From what I remember, The Matrix trilogy is about a loop and a conditional BREAK. So they wouldn't be set-based. I would call them simple RBAR. :-D:-P

timothy.shawley (8/13/2012)

---

One issue - the Leap Day calculation is missing one constraint - February does not have 29 days in Centuries not divisible by 400, ie 2100 will be 28...

The main advantage is the storage 4bytes against 20bytes.

Another advantage would be the ease of creation for new identities (SQL Server will create them automatically).

However, there's a constant debate on...

You should use an IF...ELSE... statement if you want to evaluate a condition.

With your query you're assigning the value to the variable, not comparing. It should be like this.

IF @CurrentDay...

I like Notepad++ very much, but I can't figure out why would you be interested in buying a software to run queries in it instead of doing it in SSMS.

I'm...

I can't try it in here, but have you tried to assign the default value to REPLICATE( '0', 15)?

I have an idea, but could you please post DDL before I start working on it?

Have you seen Jeff Moden's articles on Hidden RBAR?

Hidden RBAR: Triangular Joins

[/url] Hidden RBAR: Counting...

But you could change the names of the table and columns and post some DDL and...

Just guessing...

;WITH Top5 AS(

SELECT TOP 5

state,

COUNT( DISTINCT customer) AS customers

...

You could also consider using CTEs.

WITH Notifications AS (

SELECT sales_order_number

, count(sales_order_number) as Notification_cnt

FROM...