Jacob Wilkins (3/25/2016)

Careful, that CASE statement seems incorrect for the requirements.

Once b (the min of the basic running total so far) goes negative, that absolute value has to be...

This ?

CREATE TABLE test

(

id INT IDENTITY(1, 1) NOT NULL,

score INT,

...

DECLARE @TranTable TABLE (

AccountID INT NOT NULL

, TranDate DATETIME...

I guess the query part in CTE segmentsparsed is redundant and also in the final part of your query you are checking for non existence of the record in Custom_SegmentsParsed...

Without looking at the underlying tables and the query plan even the best SQL expert wont be of any help.Please post query plan,table structure and underlying indexes.

Just a shot in...

It can be done with a combination of UnPivot and Crosstab query.

;WITH cte

AS (SELECT itr_cst_key,

...

Yes you can ..Google "Server side tracing in SQL Server".Place the trace script in a SQL job and schedule it and using fn_trace_gettable read the trace file to insert the...

You can use a UpdLock lockhint on Table1.Updlock allows other reads to acquire Shared locks but will block other transactions from trying to get update or X lock on the...

Something came to my mind.For your first question merge agent can run on a distributor as well for a push subscription.So if you can set up a distributor on a...

Unfortunately referencing a column alias in the same select statement is not supported in SQL Server the way it is done in MS Access. So you probably will have to...

For your first question I probably think its not possible because a merge agent always has to run on a subscriber.For the second one you can configure replication to mark...

Forcing affinity you basically make individual scheduler bound to a particular CPU and the thread on the scheduler will be constrained to run only on that CPU and cannot be...

Shouldn't you be setting up Snapshot or Transactional replication instead ?

Grant Fritchey (3/22/2016)

Trace is trace. If you mean the trace versus Profiler GUI, yeah, the trace every time. But, capturing execution plans is expensive. Even if you went to extended...

Reorg of indexes is always executed online irrespective of the edition and is a single threaded operation.Writes are not blocked and updates to the underlying tables are allowed.