Indexing is an interesting q.

In theory I guess best would be an index on:

( dealer, article ) include ( price ) or even

( dealer, article, price )

but it...

This sql will often be more efficient, although it's not guaranteed to be:

SELECT *

FROM (

SELECT article, dealer, price,

DENSE_RANK()...

mm7861 (5/13/2015)

---

Had a slightly different requirement come in!

Need to get the previous business day of a date if that date is not a business day... again I would like to...

select

address_id,

case SUBSTRING(addr_flags, 1, 1)

when '1' then addr1

...

Yes, after the shrink, you use sys.dm_db_index_physical_stats as usual to check for fragmentation.

Ooh, btw, I forgot something earlier. Even before you do the shrink, you can check if there...

SELECT A.Date,

( --get the last of the business dates from below

SELECT TOP (1) DateKey

...

SELECT

MAX(CASE WHEN DateFY = 2010 THEN Yr_Count ELSE 0 END) AS [FY10],

MAX(CASE WHEN DateFY = 2010 THEN May_Count ELSE 0 END)...

New Born DBA (5/11/2015)

---

CKX (5/11/2015)

I think you may find this particular response from Lynn probably explains what is going on here.

You can experiment by "including" the other columns in your...

You can just use a single UPDATE statement unless you need to other actions between the SELECT and the UPDATE:

UPDATE tblOnboardingSequence

SET NextNumber = NextNumber + 1

WHERE Name =...

Personally, I would stick with the simpler / more straight forward:

IF DATEPART(MINUTE,GetDate()) BETWEEN 00 AND 05

OR DATEPART(MINUTE,GetDate()) BETWEEN 30 AND 35

BEGIN

...

END

Yes, it did :-).

A shrink is reasonable after you've deleted a lot of data. After the shrink, you can decide if you want to shrink the file to release...

Jeff Moden (5/11/2015)

---

SQL Guy 1 (5/11/2015)

---

Thanks again.

Here is the query that I came up with:

select f1.Operation,

f1.AllocUnitName,

...

Edit: In your original, change the INNER JOIN condition to this:

INNER JOIN OrderTable2 ot2 ON ot2.Order_No = SUBSTRING(ot1.Full_Order_No, 10, CHARINDEX('-', SUBSTRING(ot1.Full_Order_No, 10, 20)) - 1)

The fact is that bit-wise values can indeed be easier to maintain in certain cases, particularly for status and/or security flags. You can then add new values without having...

Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??