In SSRS design mode - you have the palette.  The size of the palette matters - if it is wider than the allowed page size - then you will get...

Compatibility mode?

Sidebar: stop using DB..Table - specify the schema instead of expecting SQL Server to find the correct schema for the table.  That is dependent on the default schema setting...

Imagine a view is created - that references a computed column which only exists to give the column a different name - and aliases the computed column to...

Also, one thing to REALLY think about is backup and recovery. Storing files in the database means restoring those files with the database. That becomes a huge headache and...

Database Disk Usage:

    USE {your database here};
     GO
     
   WITH database_size
   ...

p.s.  CTEs are inherently NOT reusable anywhere except the query that they live in.  They can be referenced as many times as you need to with the understanding that...

You can also add a computed column to the table - but I really don't see the need or requirement to create a column with multiple names.  It is just...

So - going back to the OP's original post we see that a string that is greater than 8000 characters gets inserted with truncation and is successful for columns defined...

Don't quote me on this - but I believe the reason it works for the VARCHAR(8000)/NVARCHAR(4000) columns is due to how SQL Server handles strings, string concatenation and implicit conversions.

For...

When you use a table hint you are overriding the default isolation on that table - so if you have RCSI enabled at the database level and use NOLOCK (read...

If the database is in full recovery - and you are migrating by taking a full/diff backup and then applying all transaction logs to bring the new system up to...

What problem are you trying to solve here?

If you are not going to be archiving and purging the data - then partitioning really serves no purpose.  Your thoughts of moving...

Also be careful on setting a hard-coded single number for the threshold.  For some VLDB's you could have a transaction log that is hundred's of GB's.  If that transaction log...

If you setup the AG to use automatic seeding - then the database will be automatically added to each secondary in the AG.  In order for that to work, the...

You have OR in there.   Needs to be inside parentheses.

WHERE det.CustName = @CustName
   AND ( det.InvtAcctCode = 'RENT HOSP' OR det.InvtAcctCode = 'RENT NH' )
...

• This reply was modified 2 years ago by Jeffrey Williams. Reason: Added code sample