Forum Replies Created
Viewing 15 posts - 1,216 through 1,230 (of 49,571 total)
-
RE: How much memory does SQL server Really need?
WhiteLotus - Monday, July 3, 2017 1:11 AM -
RE: DBCC CHECKDB ( , REPAIR_ALLOW_DATA_LOSS) is not fixing Db
Without a clean backup, that's not fixable. checkDB is not guaranteed to fix all problems, that's what a good backup strategy is there for (one of the things)
Restore from... -
RE: SQL Server 2000 Installation Problem
Please post new questions in a new thread. Thanks
-
RE: Are the posted questions getting worse?
Sean Lange - Friday, June 30, 2017 8:59 AM -
RE: SQL server error “No catalog entry found for partition ID xxxxx in database 12…”
Run the following in the database with the problem, post the results
DBCC CheckDB WITH NO_INFOMSGS
-
RE: log_reuse_wait_desc column says LOG_BACKUP - what should i do ?
Please post new questions in a new thread. Thanks
-
RE: More problems with SQL 2014's new Cardinality Estimator
julian.fletcher - Thursday, June 29, 2017 9:30 AM -
RE: Creating Identity column reorders table
GrassHopper - Thursday, June 29, 2017 9:20 AMThere's...
-
RE: More problems with SQL 2014's new Cardinality Estimator
ChrisM@Work - Thursday, June 29, 2017 8:43 AM -
RE: More problems with SQL 2014's new Cardinality Estimator
It's the elevated row estimations that will likely be the cause. The spools show up when the optimiser thinks it's better to cache intermediate results and read from the spool,...
-
RE: More problems with SQL 2014's new Cardinality Estimator
julian.fletcher - Thursday, June 29, 2017 3:27 AMRE: Order of Data and Cursor Fetch Next Order
tinausa - Wednesday, June 28, 2017 2:47 PMRE: More problems with SQL 2014's new Cardinality Estimator
OPTION(RECOMPILE)
On SQL 2016:
What lead me to try that was the estimated rows on the insert. 350 000 rows, which would probably...
RE: More problems with SQL 2014's new Cardinality Estimator
julian.fletcher - Wednesday, June 28, 2017 10:17 AMRE: More problems with SQL 2014's new Cardinality Estimator
It runs on my 2016 instance in 19 seconds, and I don't have a 2014 instance around. Should I see if I can fix it on 2016?
Viewing 15 posts - 1,216 through 1,230 (of 49,571 total)