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 47 (462 total posts) < 1 second(s)
  • re: Check the settings when installing SQL Server

    Yes, I agree with that aspect too. But that connect item is not just about tempdb, but anywhere that collation errors occur. System tables use the default instance collation, and we should take care to avoid errors when dealing with them too.
    Posted to Rob Farley (Weblog) by Rob Farley on July 26, 2015
  • re: Handling special characters with FOR XML PATH('')

    G - what output are you trying to achieve?
    Posted to Rob Farley (Weblog) by Rob Farley on July 24, 2015
  • Corruption, corruption, more corruption

    No, not in my systems. Corruption does happen from time to time. At LobsterPot Solutions we get calls from people now and then who have corruption in their databases, that want help getting them repaired. Generally, its not too much of a problem, although Ive seen some doozies over time. (And if you need help, get in touch!) Interestingly, I ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 17, 2015
  • re: SELECT and WHERE, but no FROM clause

    Try: &nbsp; &nbsp;SELECT * &nbsp; &nbsp;FROM ( &nbsp; &nbsp; &nbsp; &nbsp;SELECT ... FROM .... &nbsp; &nbsp; &nbsp; &nbsp;UNION &nbsp; &nbsp; &nbsp; &nbsp;SELECT ... FROM .... &nbsp; &nbsp;) AS u &nbsp; &nbsp;WHERE ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 15, 2015
  • re: Check the settings when installing SQL Server

    All code that created columns without an explicit collation is dependent on database settings already. My suggestion in the Connect item was to have a way of avoiding the error, and a few different options were provided. And the real fix is to have people always specify the collation explicitly, so that even the database collation isn't relevant, ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 14, 2015
  • re: The SSIS tuning tip that everyone misses

    Hi Sam, I find that setting FAST to be the same as the buffer size can help, as you're telling it to fill up that first buffer as quickly as possible, but sometimes smaller FAST values can help encourage Nested Loops, which can be faster in some situations. But the details about how large the buffer size should be are blurry and dependent on a ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 14, 2015
  • re: Check the settings when installing SQL Server

    You already can't execute code and just assume it's going to work. A different collation is a common cause of that. The Connect item is trying to increase the amount of code that will simply work, although of course indexing strategies need to consider the collation settings carefully.
    Posted to Rob Farley (Weblog) by Rob Farley on July 14, 2015
  • re: Check the settings when installing SQL Server

    I'm sorry you don't like the Connect item, Mark. The point of the Connect item is to have an option that means that a collation error can resolve with a warning. There is no issue specifying a collation when creating a temporary table, and DATABASE_DEFAULT is better than nothing.
    Posted to Rob Farley (Weblog) by Rob Farley on July 14, 2015
  • Check the settings when installing SQL Server

    Next, next, next, next, next... you know the drill. Except that when installing SQL, its simply not good enough. The defaults might not work for you, and that makes this post qualify for this months T-SQL Tuesday, hosted by Andy Yun (@sqlbek). Most things are fine, but there is one page which you really shouldnt ignore. And its not even ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 13, 2015
  • re: Handling special characters with FOR XML PATH('')

    Hi Nitin, What results are you after? FOR XML combines multiple rows into a single one. If you just want the columns combined within each row, then just use + and don't do the FOR XML bit at all. But maybe I'm not understanding what you're after. Rob
    Posted to Rob Farley (Weblog) by Rob Farley on July 8, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement