Thursday, November 9, 2017

Partitioning for partition elimination

With this technique, the goal is to reduce the amount of data that SQL Server needs to scan through when doing table scans. Typically, this is done by using a static window approach with many partitions created in the system and data. For example, you could put the data for each month into its own partition. This way, when users run a query, SQL Server needs to scan through only one partition instead of going through all the data.
at
Labels: , , ,

2 comments:

  1. Mukesh SinghNovember 9, 2017 at 1:32 AM

    Good Article. Congratulation for the starting....
    SQL data Tools

    ReplyDelete
  2. Mukesh SinghJune 20, 2018 at 1:35 AM

    Data is the business asset for any organisation which is audited and protected. To gain in their business, it is become very urgent for every organization to choose few good predictive data models and validates them using test data before figuring out an operationalization plan for the model to be deployed to production so that applications can consume it.
    Artificial intelligence with SQL Server

    ReplyDelete

Subscribe to: Post Comments (Atom)

SQL Script to list out name of tables and its records in the database

SET NOCOUNT ON  DBCC UPDATEUSAGE(0)  -- DB size. EXEC sp_spaceused -- Table row counts and sizes. CREATE TABLE #temptable  (      [name] NVA...