And thanks from me to you for this post.

Got the details of a stored procedure with wrong block quotes that was hindering the MODIFY command with the same error message.

Here...

I found this article pretty helpful:

https://www.mssqltips.com/sqlservertip/2473/removing-the-sql-server-management-data-warehouse/

(It's by Aaron Bertrand / MVP...)

I used it on a test environment (phew) where I had activated MDW. Silly me. Should have known better...

Ok. Here goes...

[font="Courier New"]1971 Born

1995 Junior Developer for Natural, VMS running on ADABAS

1996 First Contact. SQL Server 6.5 running small databases for our company's Intranet. Software Developer with SQL Windows...

Apparently the definition of some columns in the sys.databases table is as follows:

If a database is not ONLINE or AUTO_CLOSE is set to ON, the values of some columns may...

Hi there

I'm not sure if this is what you are looking for ...

...but...

How did I ever miss this one!

Brilliant. Thanks ever so much.

Hi guys

As I previously wrote, the licence type was DISABLED on a SAP Server running SQL Server. The SQL Server installation was bundled/installed together with the SAP installation. I am...

Hi Steve

Thanks for the article. Nice piece.

I did notice the following differences in the counter objects:

You wrote: System Object : Avg. Disk Queue Length

... I only found it in the...

Hi Ken

Thanks for your feedback. If I understand your statement correctly,

the sproc would be populating the temp table only with the maximum

values for each given dID?

I wasn't looking for...

Hi there

Ummm, I picked up on one statement and created a sproc for the master database. It returns all the basic information for locked and blocked processes in the sysprocesses...

I'm not a fully fledged DBA, but looking at the scripts I'd assume that a scan density beloew 75 percent is bad.

Ken England has a good book on "Microsoft SQL...

Hiyas.

Had the same problem with the quotes ... noticed in QA that everything was red so I added a fifth quote.

Anyway. Got a small addition here for the same...

Just to let you all know that it worked in the end.

It took 2 hours and 30 Minutes to delete the backup history (from 600 to 320 days old) from...

Well modified the script again and seems to be working so far. Changed from -20 to -2 to delete only two days worth of backup history, corrected a typo with the...

Hi to all you poor people coping with sp_delete_backuphistory

I'm having the same issue. I created the indices and tried the script. Alas, it failed! The same thing happens as with...