Viewing 15 posts - 976 through 990 (of 59,066 total)
This isn't quite correct - neither CTEs or Views are executed (materialized). Both will be incorporated into the outer query - and then the execution plan is generated.
Now, if...
October 24, 2023 at 6:22 pm
Glad to see Jeff is here, I know he'll have some interesting insight onnthis question. CTE or View, which to use and when as well as why?
Thank you for...
October 24, 2023 at 1:07 am
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 they...
October 24, 2023 at 1:04 am
Back to this older thread of "Can data save the world" and seeing what has been going on with the "climate change discussions" (and I hate to call it that)...
October 23, 2023 at 8:42 pm
If you know the SPID for the query, you could also query the following DMV. Look for the word "memory" in the documentation.
October 23, 2023 at 8:31 pm
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...
October 23, 2023 at 8:29 pm
You CAN, however, create a simple "Pass through view" that will do the trick.
October 23, 2023 at 1:54 pm
Are the rows all at the "end" of the Clustered Index or are they scattered throughout?
October 23, 2023 at 1:51 pm
Compress the data. Look at both page compression and COMPRESS/DECOMPRESS for large char columns.
As a bit of a sidebar, be aware that Page Compression causes index rebuilds to take...
October 23, 2023 at 1:40 pm
I sure don't mean for it to be false praise, or even praise for nothing. I've just seen a few people get... for want of a term, upset when...
October 23, 2023 at 4:28 am
replicate returns 8k
https://learn.microsoft.com/en-us/sql/t-sql/functions/replicate-transact-sql?view=sql-server-ver16
Lordy... I've been bitten by that before. In this case, it returns 8K because it wasn't predefined as a MAX datatype.
Let run the test a bit...
October 23, 2023 at 4:18 am
I feel that your most needed confidence is that needed for you to ask questions when you are not sure about something.
One of my biggest regrets is in not...
October 23, 2023 at 3:44 am
Just to be absolutely correct, you might want to add a PK on EmpID in the Employee table. 😀
Otherwise, awesome question!
October 20, 2023 at 7:16 pm
Actually, REORGANIZE does a whole lot...
It causes log file explosions.
It perpetuates fragmentation because it doesn't clear the pages above the Fill FACTOR.
It combines pages at the worst time possible, which...
October 20, 2023 at 7:01 pm
I'm still waiting on the OP for the DDL and Data sources for the example table.
As a bit of a sidebar, I've not yet done a deep dive on this...
October 20, 2023 at 6:34 pm
Viewing 15 posts - 976 through 990 (of 59,066 total)