nuth (12/2/2016)

---

What are the best practices when we have more than 350+ databases on a single AlwaysOn Group. I see issues like:

1. When connecting the to the instance, it takes...

Still sick and jet lagged, but what you said makes sense to me. You simply must make sure you have the FULL backup that is the basis for any DIFF/TLOG...

SQL CLR Regex would be the way I would go honestly. IIRC someone actually already built a regular expression system for SQL Server using that.

Can you explain why you cannot put an SSD in the box and drop tempdb on that?

PATINDEX gives you the position of the start of the match. So just SUBSTRING them out. The sneaky part here is doing it in a single pass. Once again my...

patelxx (12/1/2016)

---

I am learning and new to CREATE FUNCTIONS - how to I add a WHILE LOOP in a function:

CREATE FUNCTION fn_list_the_number(@count INT)

RETURNS TABLE

AS

RETURN

(

WHILE (@count <= 10)

BEGIN

PRINT CAST(@count AS...

[myexcel]...['Company'] does not look like a valid object identifier to me.

Jeff Moden (12/1/2016)

---

There's no way in hell that I'd enable TF 1117. It doesn't just affect TempDB and I don't want the nearly 90 temporal files/filegroups for a 600GB...

Mike Scalise (12/1/2016)

---

TheSQLGuru (12/1/2016)

---

Mike Scalise (12/1/2016)

---

Ohh. My apologies. I thought you were making a general recommendation for running Ola's scripts.

Yes, I could see how setting that flag in the command...

Mike Scalise (12/1/2016)

---

Ohh. My apologies. I thought you were making a general recommendation for running Ola's scripts.

Yes, I could see how setting that flag in the command might achieve the...

sandy-833685 (12/1/2016)

---

AlertsSize Bytes Per Row

dbo.IRST6553.6

dbo.Ulog5461.33333

dbo.VAE8192

dbo.IRR8192

dbo.Rdata8192

dbo.InfoData81920

dbo.IRTrans49152

dbo.IRC16384

dbo.Transactions65536

dbo.ARPin16384

dbo.IRRPT32768

Total Bytes298734.9333

Above is the details size in bytes for per transactions which and total size comes approx - 300 KB, Yes Every table has clustered and...

Options/thoughts:

1) RTFM (Read the "Fine" Manual) for Simplivity and find out how to force certain files to stay resident in flash storage, assuming your system has such.

2) Deduplication has...

cbrammer1219 (11/30/2016)

---

So I have inherited a system that is being backed up with ola.hallengren suggested ways, however when I started here there are some of the databases that the TLOGs...

Hmm, I thought you said you wanted to just delete backup files WITHOUT taking any actual backups. 🙂

Ahh, well, that's what happens when you post after days of being sick and starting an international trip. :hehe:

Taking a closer review (albeit after being sick for more days and...