Lynn Pettis (5/3/2016)

---

ScottPletcher (5/3/2016)

---

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...

cookiemonstagt (5/3/2016)

---

Oh my

.. thanks and one last question if the db is shared each node has these 3 files to be able only to run the...

You need to create an index on ID in T2, T3, T4, T5 and T6.

You should check the tables in the order of most likely to EXIST first, so that...

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...