New answers tagged

2

Very easy. Look for the result of: select datediff(day,'1/1/1950','12/31/2007'); It will give you your DISTINCT_RANGE_ROWS + 1 That means that SQL Server thinks that all your DOBs are approximately equally distributed across the range with average 236 items per day. Query your data and see if you have any outlines like: missing day ranges or >1000 DOBs ...


3

The only major difference is that SQL Server will only ever create single column statistics. You can create multi-column and filtered statistics. If any of the statistics you created were those types, they may be important. If not, SQL Server is likely to have created system statistics on those single columns, when deemed useful to a query. Unfortunately ...


2

If you're asking about the editions of SQL Server 2016 supporting R Services (R integration), I believe that basic R integration is supported by pretty much all editions. Advanced R integration is only supported by Enterprise and Developer Editions. Here's more detailed information by Microsoft that might help: Features Supported by the Editions of SQL ...


2

is there a statement to check if a specific index's auto stats is disabled? You can use sys.sp_autostats or sys.stats to get this information. sys.sp_autostats can also be used to enable or disable automatic updates for a particular statistics object. For example, using the AdventureWorks sample database: EXECUTE sys.sp_autostats @tblname = N'[...



Top 50 recent answers are included