Viewing 15 posts - 346 through 360 (of 2,863 total)
There was some problems with your CTE's for the between_rows data due to the filter on RN=1. That shouldn't be applied on the between_rows set of data (happens higher up...
January 8, 2024 at 10:06 pm
Feel free to ask. In my experience, I haven't needed to use the import functionality before. I've exported when I needed a data dump of all my reports to disk...
January 8, 2024 at 8:15 pm
This looks like a homework or assignment or an interview question, so you will forgive me for not just spitting out a full TSQL query for this. What is always...
January 8, 2024 at 8:12 pm
The best way I know how to do it then is to do an export to disk and then import it back in a new folder.
Here is the export script:
January 8, 2024 at 3:24 pm
@graham.hitchings - A unique column will have high cardinality too based on the link in the QOTD. It states:
An example of a data table column with high-cardinality would be a...
January 5, 2024 at 6:53 pm
Just wanted to add to Thomas Franz's third paragraph - from my experience, when people are being let go, it is SOMETIMES based on how important and how good they...
January 5, 2024 at 6:06 pm
As far as I know, there is no way to do that. The best solution I know of is to make a new folder and push the files over manually...
January 5, 2024 at 5:44 pm
If it is "results to screen", it is more likely the rendering on screen that is the slowness and not the data retrieval/download process and in that case, an indexed...
January 5, 2024 at 4:58 pm
ALSO I am not saying "don't use indexed views", I am saying test it. Even just adding 1 index will impact INSERT, UPDATE, and DELETE performance (and can impact SELECT...
January 4, 2024 at 8:02 pm
Just a heads up about indexed views - in SQL Server Standard, indexed views must be explicitly requested to use the index. In enterprise the query optimizer will use the...
January 4, 2024 at 3:59 pm
Just wanted to add, I liked the article. I wasn't trying to criticize it, especially since I've never had the guts to post one on here. I just wanted clarification...
January 4, 2024 at 3:25 pm
Another thing that ties into what Grant said - if this is SSIS, those 22M rows are likely trying to be stored in memory. If you don't have enough memory...
January 4, 2024 at 3:23 pm
I am slightly confused by the last example - Integrating NTILE with RANK(), DENSE_RANK(), LAG(), and LEAD(). You have both LAG and LEAD partitioned by EmployeeId and EmployeeID is unique...
January 3, 2024 at 8:45 pm
Another thing it COULD be is do you have that excel file open in any other tool (Excel for example)? If it is on a shared drive, is the excel...
January 3, 2024 at 5:09 pm
Good advice... do something out of my comfort zone... RELEASE DIRECTLY TO PROD!!!
Just kidding. My goal is to get back into photography. I kind of dropped out of that for...
January 3, 2024 at 3:45 pm
Viewing 15 posts - 346 through 360 (of 2,863 total)