The READPAST hint is very helpful in those types of situations. I believed it was designed to help handle these types of "queue assignment" queries.

Detach can get messy, esp. with the file security changes that occur.

I'd just restore the backup 20 times. You could bundle the entire process into a master job and...

Alexander Suprun (3/20/2015)

---

ScottPletcher (3/20/2015)

---

You'll want to explicitly state the FILLFACTOR and the filegroup, at least, rather than accept whatever the defaults happen to be:

CREATE UNIQUE NONCLUSTERED INDEX <index name>

ON...

I think you can do it by running from master and explicitly specifying the actual db name in the query:

use master

select *

FROM your_db_name.dbo.Registos r

CROSS APPLY your_db_name.dbo.fnObtemCategoriaAviacao(r.PaisOrigem, r.PaisDestino)

Note that the original query and the new query will produce different results if the column can contain NULLs. You need to construct your final query to handle NULLs...

You'll want to explicitly state the FILLFACTOR and the filegroup, at least, rather than accept whatever the defaults happen to be:

CREATE UNIQUE NONCLUSTERED INDEX <index name>

ON <Table Name> (...

Shrink does not always fragment indexes; it certainly does not always fragment every index. You can shrink as much as you really need and then rebuild/reorg any index that...

Not in the specific case where you're only looking...

Readers don't block writers, and writers don't block readers. Without RCS on, they do. This is a wonderful option, but it comes with a fairly high overhead cost,...

ichayan2003 (3/19/2015)

---

Thanks SScrazy for your input on this. But i am trying to avoid Is Null as there is a chance for null value on my tables.

As GilaMonster suggests, i...

SELECT A.*

FROM Table1 A

LEFT OUTER JOIN (

SELECT B.USERID

FROM Table1 B

INNER JOIN Table2 C ON B.USERID=C.UserID

)...

I don't see any downside, only upside. SQL relies on those settings now anyway, and they will soon be required.

Interesting. If the db is "READ_COMMITTED_SNAPSHOT ON", that will typically reduce locking/blocking considerably. When tasks are in READ_COMMITTED isolation level -- which is the default -- the only...

I came across another snag. 🙁 There is also another column "Validated hour" which is just a sum of hours...

SELECT

time_char,

STUFF(CONVERT(varchar(5), DATEADD(MINUTE, 15, STUFF(time_char, 3, 0, ':')), 8), 3, 1, '')

FROM (

SELECT '0545' AS time_char UNION ALL

...