THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 52 (516 total posts) < 1 second(s)
  • re: sp_updatestats2

    the key is that indexes in which the lead key is not unique need a fullscan statistics, my intent was that this procedure run daily, hence turning off auto update - norecompute is ok. At the time, I did not want an auto statistics recompute to override the fullscan. When I did this, we did not have PERSIST_SAMPLE_PERCENT (new in &nbsp;SQL ...
    Posted to Joe Chang (Weblog) by jchang on April 9, 2018
  • sp_updatestats2

    -- this is my version of sp_updatestats Some of you know that SQL Server has a problem with the way statistics are sampled. Indexes in which the lead column is not unique can be adversely affected. My system procedure marks indexes which are either not unique or has more than one key column for full scan statistics. If you have an index ...
    Posted to Joe Chang (Weblog) by jchang on April 5, 2018
  • re: sp_spaceused2

    I know that there are people who like documentation. Personally, I follow the school of Gert Drapers: &quot;the source code is the documentation.&quot; Not only that, it is guaranteed to be correct! I probably should write something on how I use this information, which would do more to explain why I have it in the first place. Perhaps after I ...
    Posted to Joe Chang (Weblog) by jchang on April 5, 2018
  • re: sp_helpindex2

    feel free to modify the column names as you desire. I am a big proponent of its important to be able to see all important data together, hence the compact column names. To this end, I recommend 4K, 28-32in monitors. 28in 4K has been low priced for a while. Now even 4K 32in is not too expensive.
    Posted to Joe Chang (Weblog) by jchang on March 12, 2018
  • Low Latency Memory

    For the last twenty years, the standard practice has been to scale server performance with multi-processor (MP) systems. What is not widely understood is that after processors integrated the memory controller, the initial step from single processor to 2-way has only moderate scaling due to the introduction of non-uniform memory access ...
    Posted to Joe Chang (Weblog) by jchang on March 8, 2018
  • re: sp_spaceused2

    Hikari, you can change the name of this procedure to anything you would like, if you are not dbo in master, then you need to just make this a regular procedure in the database you normally use, and skip the mark as system proc at the end Rambo, first or second blood? you may not be able to create this in master. if not, then just create the ...
    Posted to Joe Chang (Weblog) by jchang on March 2, 2018
  • re: Asymmetric Processor Cores

    My thinking is the asymmetric nature of the cores is exposed via the OS API. SQL Server in turn would expose it via Resource Governor. Transactions that involve few rows would use the Atom cores, the big cores would run queries involving many rows, index rebuilds etc.
    Posted to Joe Chang (Weblog) by jchang on February 28, 2018
  • sp_helpindex2

    this is my extended version of sp_helpindex sp_helpindex2 lets face it, sp_helpindex is old and has not been updated for all the new features of SQL Server introduced since the beginning. sp_helpindex provides a list of indexes, information on: the type (clustered, unique, primary key, statistics no recompute), and file ...
    Posted to Joe Chang (Weblog) by jchang on February 23, 2018
  • sp_spaceused2

    this is my version of sp_spaceused. Instead of just overall spaceusage, all tables are shown with extended information. --sp_spaceused2 USE master -- skip this for Azure GO IF EXISTS ( &nbsp; SELECT * FROM sys.procedures WHERE object_id = OBJECT_ID('sp_spaceused2') ) DROP procedure [dbo].sp_spaceused2 GO ...
    Posted to Joe Chang (Weblog) by jchang on February 23, 2018
  • Asymmetric Processor Cores

    Most Intel processors use one of two cores, the main-line core and the Atom core. Desktop processors might use the newer Kaby Lake or Coffee Lake micro-architecture cores, while the Xeon SP lines uses the previous generation Skylake micro-architecture. All of these are part of the main core line. The Atom core is used in Xeon Phi, Atom and ...
    Posted to Joe Chang (Weblog) by jchang on February 20, 2018
1 2 3 4 5 Next > ... Last »
Privacy Statement