THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 38 (372 total posts) < 1 second(s)
  • 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;http://sqlblog.com/blogs/tibor_karaszi/archive/2016/06/30/books-online-for-sql-server-2016.aspx. 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
  • Books Online for SQL Server 2016

    This one is for those of you who prefer to use a local SQL Server Documentation, a.k.a. Books Online (BOL), instead of using the web-based BOL. A local BOL is essential for me. Navigating the contents, switching between pages and searching is lightyears ahead and quicker in the local BOL. (Update: Added bits about the missing ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on June 30, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement