A lot of people make the mistake of thinking that a CTE is rendered as a separate object.  Unless there is a "blocking operator" in the CTE, it's treated like...

Thanks for taking the time, Henrik.  A lot of people will continue to be "stuck" in 2008 R2 for one reason or another and so I wanted to know what's...

Thanks for taking the time to post back, Randy.  Since you're one of the folks that needs to support it, do you know how it works?

Sorry... duplicate post removed.

Yowch.  Thanks for the info, Phil.

Based on the fact that all execution plans are thrown away during a reboot or restart of the SQL Server Service and you said the server suffered a reboot or...

You first need to find out what the code that uses the table looks like.  DW tables are NOT usually "proper normalized tables".  For example, removing the "month" column or...

The OP is just spamming.  It's a BS request to try to get past the SPAM filters.  I hate these people and won't do business with any company advertised by...

Totally agreed and thanks for the the feedback, Jonathan.  I also do the "partial backups" to exclude Read_Only file groups, sometimes in concert with having the large table in a...

hi Jeff, That is going to be useful, at least for me. But I could not get it to work on SQL Server 2008 R2 (not that it is...

Thanks Sreedhar... Ur expression works but the variable has datetime datatype so it converts it to 6/7/2019 5:00:00 PM format rather than 2019-06-07 17:00:00.000.  Anyway Thanks for all ur...

-- SV: For understanding getdate() and things you need
select SYSDATETIME() as sysdatetime_FYI
, getdate() as getdate_FYI
, cast(getdate() as time) as getdate_TimeOnly
, CONVERT(varchar(15), cast(getdate() as time),100) as getdate_TimeOnly_AMPM
,...

I used to display long strings in a similar matter and even wrote a similar article (didn't know Timothy had already written one back then).  A fellow by the name...

I've done this but not the way you want.  It's super simple, though.  Create another database, move your large table to that, and create a synonym in the original database...

ok thanks for all the posts.  First this is a view, and I now know declare statements do not work in a view so I updated the statement to...