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 40 (398 total posts) < 1 second(s)
  • re: SQL Spatial: Getting “nearest” calculations working properly

    Hi Milan! Thanks for responding. We should talk about PDW more too... Anyway - I think the docs aren't bad, but the keys are the bits around points 3 and 7, plus the fact that the example doesn't actually use the indexes on my machine! So I wouldn't mind an explicit explanation in the page saying &quot;The query must include an explicit ...
    Posted to Rob Farley (Weblog) by Rob Farley on August 20, 2014
  • re: Nepotism In The SQL Family

    Justin - yes, I'm being somewhat flippant about the times when nepotism is a problem. I've seen it many times in many different situations, and never (I think) benefited from it. But I've also reflected on some situations over the years and figured that often those people were probably the best choice, because the hiring manager had stronger ...
    Posted to Rob Farley (Weblog) by Rob Farley on August 17, 2014
  • SQL Spatial: Getting “nearest” calculations working properly

    If youve ever done spatial work with SQL Server, I hope youve come across the nearest problem. You have five thousand stores around the world, and you want to identify the one thats closest to a particular place. Maybe you want the store closest to the LobsterPot office in Adelaide, at -34.925806, 138.605073. Or our new US office, at ...
    Posted to Rob Farley (Weblog) by Rob Farley on August 14, 2014
  • re: Nepotism In The SQL Family

    Adam - exactly. It's an open group and preferring people with a strong sense of community is by no means the same as hiring your nephew.
    Posted to Rob Farley (Weblog) by Rob Farley on August 13, 2014
  • Nepotism In The SQL Family

    Theres a bunch of sayings about nepotism. Its unpopular, unless youre the family member who is getting the opportunity. But of course, so much in life (and career) is about who you know. From the perspective of the person who doesnt get promoted (when the family member is), nepotism is simply unfair; even more so when the promoted one ...
    Posted to Rob Farley (Weblog) by Rob Farley on August 12, 2014
  • re: LobsterPot Solutions in the USA

    Not just yet, Jeff.
    Posted to Rob Farley (Weblog) by Rob Farley on August 6, 2014
  • LobsterPot Solutions in the USA

    Were expanding! Im thrilled to announce that Microsoft Gold Partner LobsterPot Solutions has started another branch appointing the amazing Ted Krueger (5-time SQL MVP awardee) as the US lead. Ted is well-known in the SQL Server world, having written books on indexing, consulting and on being a DBA (not to mention contributing chapters to both ...
    Posted to Rob Farley (Weblog) by Rob Farley on August 4, 2014
  • re: Re-running SSRS subscription jobs that have failed

    Hi Nevarda, You should be able to query the first box using the tables: Subscriptions, Catalog, Users, ReportSchedule, and Schedule. You should have the Catalog and Users in place, and you'll need to get the appropriate uniqueidentifier values for the fields involved. Then you should be able to create the necessary Schedule and ReportSchedule ...
    Posted to Rob Farley (Weblog) by Rob Farley on July 22, 2014
  • re: SSIS Lookup transformation in T-SQL

    Hi Surjit, The first predicate is on the set d1, which is reflected in the Startup Filter. It means it only does this lookup if the first one (d1) has failed to find something. The second predicate is on the tables d and f, and is used to find the record in the dimension table. Does this help? Rob
    Posted to Rob Farley (Weblog) by Rob Farley on July 16, 2014
  • re: Handling special characters with FOR XML PATH('')

    Ali - sorry for not responding sooner. Try using a binary collation...
    Posted to Rob Farley (Weblog) by Rob Farley on July 11, 2014
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement