I have experience with two large systems - one with FILESTREAM blobs and the other using normal blobs.  Both ultimately got migrated out of the database into an object store. ...

I wouldn't store the fully qualified path for each file.  The files will probably need to be moved to a different location at some point.  I'd store a relative reference...

I have some experience in this area and I would advise against storing files in the database - using FILESTREAM or otherwise.  This blog post might be worth a...

I created a monitoring tool, DBA Dash that collects VLF counts for your SQL instances.  The GUI has a nice report that shows you the maximum VLF count for...

I had a 160TB db at one point.  A large % was blob data and the associated table was INSERT only. We also had another activity log table that was...

I wrote my own monitoring solution that has recently gone open source.  It might be worth a look (I'm biased, but it's free and open source):

https://github.com/trimble-oss/dba-dash

I would also take a...

Yeah - I'm using SMO to script the database objects.

Hope this helps,

David

VARCHAR(8000) can store 8000 characters. You can prove...

michael bourgon (5/22/2012)

---

Nice to see someone else working on DDL auditing via XE. Is it possible to get a copy of the code without the application? I can...

I don't have any plans to charge people for the application and it's unlikely that there...

Jeff Moden (3/16/2012)

---

Ah, understood. I was going by what you had posted for code.

Shifting gears a bit, I'm concerned about your "busy" Temp DB. This is frequently caused...

Hi Jeff,

That solution would work, but it requires changes to the way the application works. The application currently calls one stored procedure to do the initial insert and another...

PS

The transactionid solution is really just a different version of the flag based solution. It seems a bit crazy that you need VIEW SERVER STATE permissions to get your...

Hi,

Thanks for the suggestions.

Vedran - That's more or less the same solution that I came up with, but it's good to see that someone else was thinking along the same...

LutzM (3/14/2012)

---

Let's assume the requirement to store the file in a table is really required (instead of just the insert of a link to the file system...).

If it needs to...