hey Ken .. wishing you a safe and faster recovery. Prayers for your well being !

Any downsides in performance that is actually encountered when patches are applied ?

Enable trace flag 1448. That will help replication configured with AG.

For future visitors, you can use https://dbatools.io/ - its powershell based tool that helps migrate entire instance or selected databases from one server to another including everything - linked servers,...

Why not address the root of problem ? Is your database...

dgmueller (12/17/2015)

---

I ran this script and received the following errors:

Msg 170, Level 15, State 1, Line 71

Line 71: Incorrect syntax near 'max'.

Msg 156, Level 15, State 1, Line 87

Incorrect syntax...

dave-L (11/24/2015)

---

I've enabled trace flag 1800 on all replicas now and I'm still receiving this error. I did not restart the SQL service though. I place the trace flag in...

>> What if we have to migrate...

Rudy Panigas (9/29/2014)

---

Why would I...

Contrary to the title, the query does not show the indexes.

Below is an enhanced version (courtesy of Aaron Bertrand)

;WITH src AS

(

SELECT

...

why are you using undocumented sp_msforeachdb ? There are better ways of doing it.

Aaron Bertrand has a better way...

rnithish (1/1/2014)

---

My project involves a business requirement to capture the activities that occur daily which might average to over 500 entries per day. Although SqlServer can handles billions of rows,...

Highly suggest to look into : SQL Server & Windows Documentation Using Windows PowerShell[/url] by Kendal Van Dyke

It collects much more info and is flexible.

Sean Smith-776614 (12/11/2013)

---

Interesting.

You could also do something like this:

WITH CTE AS

(

SELECT

1 AS number

UNION ALL

SELECT

X.number + 1 AS number

FROM

CTE X

WHERE

X.number + 1 <= 100

)

SELECT

REPLICATE ('|', X.number) + REPLICATE ('.', 100...