You can backup the dbs using the commands below from within SSMS or other appropriate SQL utility. Since someone has gone to the trouble to cluster the SQL instance,...

Using HAVING eliminates a pass of the table and makes it easier to specify different conditions.

SELECT mt.*

FROM@myTable mt

INNER JOIN (

SELECT ColumnA

FROM @myTable

...

--pull first four digits in a row that start with 2, should be year.

SELECT SUBSTRING(@@VERSION, PATINDEX('%2[0-9][0-9][0-9]%', @@VERSION), 4)

As always with triggers, the biggest issue is to make the sure the triggers are coded properly, i.e. they deal with sets and not a row at a time, and...

First, look into implementing snapshot isolation (SI) for the underlying db(s). If nothing else, if will reduce contention issues while you tune the indexes. Be sure to adjust...

If "MyOtherTable" has an index on O.ID, add "IsPurged" to the key of that index.

I can't imagine any problem with a column named "number", since number is not a reserved word in SQL Server anyway.

I must admit, I don't generally worry too much about...

It sounds like:

at least one nvarchar is working its way into some concatenation or other string operation, forcing the string to become nvarchar, and thus a max of 4000 bytes.

or...

IF EXISTS(SELECT 1 FROM dbo.ShiftScheduler WHERE ShiftType=2 AND Emp_Code='2414')

SELECT FromDate,enddate,Shift,ShiftType

FROM dbo.ShiftScheduler

WHERE ShiftType = 2 AND EndDate...

Try code something like below.

Btw, the GroupAssignment table does not need an identity column. The unique clustering key should be either ( GroupID, UserID ) or (...

Fwiw, I prefer the a different way to check the current ansi / connection settings, using:

@@OPTIONS

I actually use a table of config values so the code is more readable, but...

You can use CROSS APPLY to assign an alias name to value(s). You can then use that alias in subsequent code, even in another CA. That is, alias...

If the table is clustered first on that datetime, the purge is easy and it should have very minimal effect on current queries.

If it's clustered differently, you have a more...

You probably want to verify that the dates are actually backwards before swapping them:

update tableA

set StartDate = EndDate,

...

Can you give any example of where converting a literal value to appropriate non-unicode literal could ever cause SQL a performance issue?

Or for dates. Our rule is you convert...