Viewing 14 posts - 1 through 14 (of 14 total)
But use of memory for the recursive solution is not a problem until someone uses that code 40,000 times in an hour!!!!!!
But the first solution can fail, the second...
August 23, 2018 at 7:55 am
One of the big problems when we are writing SELECT statement is, that there is not only one solution. And we should choose the right solution to a given problem....
August 23, 2018 at 7:31 am
Why do it in such a complex way. Use recursion, which also is faster in this situation! Tally is only the fastes way if there are MANY, MANY days - not...
August 23, 2018 at 1:29 am
March 12, 2018 at 4:56 pm
March 9, 2018 at 11:39 am
It is more easy to use the Sort-task. Use the Check-box 'Remove rows with duplicate sort values'. It is a blocking task, but works fast even with millions of rows! It...
January 30, 2017 at 11:18 pm
The same rules as for other tables!!! If it is possible - and it will always be possible to alter from VARCHAR(50) to NVARCHAR(100) - then it's also allowed for...
October 21, 2016 at 5:07 am
It is not a problem to change datatype from length 50 to 100. But it can be a problem to change from 100 to 50 if a row has a...
October 21, 2016 at 4:33 am
Hi,
when you drop a column, the column is also droped in the history table. So you must save the columns data from the history table in another table before you...
October 21, 2016 at 1:47 am
It is possible to add a new column, to modify a column and drop a column, while system_versioning is ON!!!
USE master;
GO
DROP DATABASE IF EXISTS TemporalDB;
GO
CREATE DATABASE TemporalDB;
GO
USE TemporalDB;
GO
CREATE TABLE dbo.Person
(
...
October 20, 2016 at 3:18 am
It could turn into a big problem at a later date, if a production DB's recovery model is set to SIMPLE. Simple for test and Full for production. Are...
October 29, 2015 at 10:50 am
It is wrong to say that the answer is - nothing. It is also wrong to say, that a table is blank. It is - an empty table! Every select-statement...
October 14, 2015 at 2:00 pm
I agree, that this is poor article. And the article should be removed.
If someone read this article without reading the comments from RK they will have a bad solution after...
May 21, 2012 at 4:35 am
Viewing 14 posts - 1 through 14 (of 14 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy