FYI: the wheel's been re-invented countless times, or we'd all be riding around on wooden wheels with no rims!

SELECT RTRIM(LEFT(CustomerName,CHARINDEX('*',CustomerName + '*')-1))

As long as you have fixed leading values, i.e. 'value1%' and not '%value1%',

an index on myColumn should handle the query fine. If it's a large % of the...

If you're using Enterprise Edition, just use Change Data Capture and let SQL do all the hard work for you.

If not, the overhead of what you want to do is...

Sorry, extremely busy, but here's the re-write. I couldn't test it, of course, so you'll have to do that ;-):

Set NOCOUNT ON

If Object_ID('tempdb..#auditlogidsToArchive') > 0

Drop...

Need to clarify whether the other part of my initial impressions was true or not:

Is logtimestamp from the original insert, and so will also always ascend in conjunction with the...

Stamey (12/4/2013)

I have figured it out, thanks to Google and an example from guys from 'rola. ... I changed it around so that the commit is in the Try and...

The quick and very-dirty-in-this-case "solution" is to put a COMMIT TRANSACTION immediately before the END TRY.

But the whole process overall could be a lot cleaner and faster, particularly if:

auditlogid is...

keyser soze-308506 (11/27/2013)

---

Hi

I have a query like that

select c.client_group, s.product_id, count(*) as q

from Sales s

inner join Client c on c.client_id= s.client_id

group by c.client_id, s.product_id

the Sales.pk (clustered index) consist of...

L' Eomot Inversé (11/26/2013)

---

ScottPletcher (11/26/2013)

---

Luis Cazares (11/26/2013)

---

Here are 2 options to perform your calculation:

SELECT ABS(DATEPART( dayofyear, CutoffDate) - DATEPART( dayofyear, GETDATE())),

ABS(DATEDIFF( day, DATEADD( year, DATEDIFF( year, CutOffDate, GETDATE()), CutOffDate), GETDATE()))

FROM...

I don't think the...

I'd expect the restore time to generally be longer; if restoring to a new database, potentially significantly longer.

For a backup, SQL only needs to backup the active portion of the...

You could create a separate "key master" table, containing only an identity column and the four natural key columns, clustered on the natural key columns, NOT the identity.

Then, the first...

Use view "sys.dm_db_index_operational_stats".

Capture the values at the start time, then recapture them at any subsequent time, subtract the two values, and voila, you have the mods that occurred during that...

I'm not sure why you would want to insert all iterations of the list of values into the countryid table, but this should fix a couple of the potential errors...