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 38 (373 total posts) < 1 second(s)
  • Adjust autogrow setting for your database files

    I very frequently see too small autogrow value for database files.&nbsp;Even the default in many cases. The defaults prior to&nbsp;SQL Server 2016&nbsp;are 1 MB for data files and 10% for log&nbsp;files, adjusted to a little bit better values in 2016. One of the tings I often do when I start working on a SQL Server is to adjust the values to ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on December 20, 2016
  • Keep more history for your Agent jobs

    SQL Server Agent is in my opinion way too restrictive when it removes old job history information. This information is store&nbsp;in the dbo.sysjobhistory&nbsp;table in the msdb database. Unfortunately, Agent will by default only keep 1000 rows in this table. I have on many occasions wanted to for instance check last execution of the weekly job. ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on October 16, 2016
  • Log Page Life Expectancy over time

    You often see Page Life Expectancy referred to as an interesting performance monitor counter. And it can be! It&nbsp;indicates for how long a page is expected to stay in cache, from the time it was brought into cache. But just looking at a snapshot value doesn't say that much. It might be high, but that is because you haven't had a high turnover ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 7, 2016
  • Update for Books Online with functioning index (2016)

    Good news, everybody! Microsoft recently released an update for the local Books Online, with a functioning index for the relational engine. Earlier versions were missing those index bits, but not for everyone (a theory is that it depends on what server you hit when you downloaded the BOL bits). Basic steps to get them (see my earlier blog, ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on September 6, 2016
  • Poll, do you have an index for your local SQL 2016 BOL?

    This is for those of you who has installed the SQL Server 2016 documentation locally. If you haven't and want to do that, then read this:&nbsp; My question is whether you have an index for the relational database topics? For instance, using the ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 12, 2016
  • re: Books Online for SQL Server 2016

    Yes, Andreas, the old &quot;F1 and it just worked&quot;-times. I also discovered that the index isn't there - will add to the blog post now...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 7, 2016
  • re: Books Online for SQL Server 2016

    Correct. The F1 bit, I got covered above: &quot;F1 from within SSMS will always take you to the web based BOL.&quot;. The Property pages help, I never use. I always script the commands and read help about the commands instead :-). But I see that now, for me it even goes to HelpViewer 1.1. Bummer.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2016
  • July SSMS 2016 changes transaction semantics

    This can be a very nasty one if you're not observant. The July update of SSMS now has the option to change XACT_ABORT setting for a query window usingToolsOptionsQuery ExecutionSQL ServerAdvancedSET XACT_ABORTNow, exposing one more SET option can't be bad, right? But Erland Sommarskog found out that this is checked by default. Now, using ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 5, 2016
  • re: Books Online for SQL Server 2016

    Hmm, yes, I just fired up VS (actually SSDT, but it is the same shell, and I believe I have the VS product also installed here). And, indeed SQL books wasn't there. I bet it has to do the the argument provided such as /catalogName SSMS16. I'm sorry, but I don't know if downloaded books can be shared among catalog names. Perhaps there's an MSDN ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 3, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement