I'm watching some Brent Ozar videos ( Like this one ) and he says to not prefix tables with TBL.
On the internet I found some blogs saying it adds nothing do documentation, and it says that "it takes longer to read it ".
It this really a problem? Because i'm prefixing tables with tbl since my ...
One scenario where knowing beforehand whether an object in an unfamiliar script is a table or a view can be useful is when you want to quickly find it in SSMS's Object Explorer. However, you can relatively easily sp_help yourself in this case.
I mean even if you need it, when you are writing code for the same database, you will become familiarized at some point and know which are tables and which are views.
@Philᵀᴹ I'm disappointed - surely you have a table where they preface column names with the current table name. You know, for when those columns suddenly become detached the DBSurgeon can reattach them
Thank you @Shanky. Your last comment has answered my question. I don't know a way of marking comments as the accepted answer. — Stackoverflowuseryesterday
In which I probably go a little overboard answering a Stack question: http://dba.stackexchange.com/questions/154227/pagination-in-sql/154248#154248 PasteThePlan comes in so handy for this.
@PaulWhite you guys have a crazy wild life over there
This is what nightmares are made of! Australian woman's snap of mammoth huntsman spider terrifies arachnophobes!… https://twitter.com/i/web/status/794127846272733184
This is probably a stupid question, but I'm curious now after I opened the refrigerator looking for eggs to make a cake and there was only one and it was cooked. Is there any way to undo that, whether at home or an industrial way?
I shouldn't be storing binary files in an SQL database right? I'm using SQL Server. The files would range from a few kbs up to around 50 Mbs. It'll be mostly images but also PDFs and other documents.
The main reason I'm asking is because my approach is currently to just store the files in a folder and then store the path in a table. But SQL Server has the FILESTREAM type which seems to do the same, but I'm not sure.
Looks like FILESTREAM isn't an option at the moment, so a filepath it is.
What is the best place for storing binary files that are related to data in your database? Should you:
Store in the database with a blob
Store on the filesystem with a link in the database
Store in the filesystem but rename to a hash of the contents and store the hash on the database
Something ...