Viewing 15 posts - 2,836 through 2,850 (of 26,488 total)
June 7, 2017 at 12:32 pm
June 7, 2017 at 12:31 pm
It is possible that tempdb was set to an initial size of 30 GB to prevent repeated growth of tempdb after SQL Server restarts. This makes sense if tempdb growth...
June 2, 2017 at 2:07 pm
As Sue indicated, it isn't necessarily the number of rows but the percentage of data being deleted from each table. If you are deleted 10% of the data then moving...
June 2, 2017 at 1:52 pm
I know how but don't know exactly how in your situation. We could use the DDL (CREATE TABLE statement) for the table(s) involved, sample data for each of the table(s)...
June 2, 2017 at 1:43 pm
June 2, 2017 at 11:09 am
WHEN ID IN ((3333,, 4040,,4545)) THEN THEN 'Copy needed''Copy needed'
This:
WHEN ID...
June 2, 2017 at 8:11 am
June 1, 2017 at 1:42 pm
May 26, 2017 at 9:02 am
May 25, 2017 at 1:19 pm
May 25, 2017 at 8:23 am
May 24, 2017 at 10:29 am
May 22, 2017 at 1:10 pm
InterBase had both BEFORE and AFTER Triggers. I liked that as well, and having them in SQL Server would be a great addition.
May 22, 2017 at 10:34 am
Viewing 15 posts - 2,836 through 2,850 (of 26,488 total)