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 33 (324 total posts) < 1 second(s)
  • re: Does your 3:rd party backup software ruin your SQL Server backup plan?

    One can only speculate, Dave. I agree that there can be valid reasons, like for instance you have mirroring *and don't want log backups*. Etc. My guess is that the backup vendor has heard of problems with large ldf files and thought it is a good service to have that option to truncate the log after the backup was performed.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 9, 2014
  • Does your 3:rd party backup software ruin your SQL Server backup plan?

    Sounds scary, huh? And it surely can be! Heres an example of one such case:&nbsp;A client of mine had implemented a 3:rd party backup solution in their VM Ware environment. This shouldn't affect the SQL Server backups. Or that was the plan. I wont mention what backup software this is, since Im sure that there are other software also doing ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on April 8, 2014
  • re: Truncate Table – DDL or DML Statement?

    I've never considered TRUNCATE TABLE could be seen as a DDL command. It doesn't &quot;define&quot; any data structure. Rather it manipulates data. I'm all with you there. (As an aside, it is listed under &quot;data manipulation&quot; in SQL 2011 standard.) I think that DDL is polluted. Do we define the (logical (physical?)) data structure with ...
    Posted to Dejan Sarka (Weblog) by TiborKaraszi on March 28, 2014
  • re: How often do you rebuild your heaps?

    Rich, I have now added option for rebuild based on free space in the heap pages.
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 21, 2014
  • re: Setting max server memory

    Agreed. It serves as a starting point, and should be adjusted for edge cases etc. :-)
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 20, 2014
  • re: Setting max server memory

    Hi Shanky, The column changed name between 2008 R2 and 2012. I changed the script to handle that. Thanks. I however don't want to touch the actual formula. The main reason for this blog was to have somewhere to point to when I get this question. I initially thought of only pointing to Jonathan's blog post. But then I decided to add some TSQL to ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 20, 2014
  • re: Do you want improved performance?

    Good blog posts, Simon! :-) Yep, not only cool, but also for me a very unexpected move as well. As you said, Durability has in my mind been cast in stone, so to speak. Please post back if you remember when you're done with your 3:rd article on this. One thing that I'm curious about is what is the actual potential for data-loss? A hard shutdown ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 12, 2014
  • Using whoami to check for instant file initialization

    Read this if you want to read more about instant file initialization (IFI). In an earlier blog post, I posted a script that uses trace flags, created a dummy-database and then sp_readerrorlog to check for IFI. Another option is to use the OS command whoami, as documented here. Below script uses whoami to check for IFI, or more precisely SQL ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 12, 2014
  • re: Setting max server memory

    Hi Uri. I assume you mean a cluster when you have more than one instance. Yes, if you normally have one instance on a node and then bacause of a fileover happens to have two instance, then you will have to adjust for that. In that case, you have several inatnces on a machine, which I explicitly commented in the code I posted. :-)
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 9, 2014
  • re: How often do you rebuild your heaps?

    No, Rich, that is something I didn't consider! Interesting. Shouldn't be difficult to add that logic to the procedure. Thinking out loud here... I guess we would use the avg_page_space_used_in_percent, and if higher than @rebuild_if_free_space_percent_is_greater_then then we do rebuild. I would prefer to not complicate the interface to the proc - ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on March 7, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement