Viewing 15 posts - 6,481 through 6,495 (of 39,877 total)
Arrgghhh, WRs didn't show up and despite a high score, apparently Mr. Ryan wasn't interested in his stats.
Grr.
September 18, 2017 at 9:01 am
I was actually owed beers, but I thought this would be a funnier scenario.
Fortunately in the real world, the tally was much closer to zero.
September 18, 2017 at 8:59 am
Cut/paste? :laugh:
I love Prompt, and every once in awhile I don't have it and my productivity goes down.
I've definitely enjoyed templates over the years, and...
September 15, 2017 at 3:16 pm
We usually do this with joins.
select l.*
from lineitems l
inner join orders o
on o.orderid = l.orderid
where customerid = @customerid
September 15, 2017 at 1:58 pm
LOL, I can understand that. The serverless stuff is interesting for some things. Not sure I'd use it for ETL either, but you certainly could just query/update things. Tracking how...
September 15, 2017 at 1:36 pm
It's documented. There are a set of features in SQL Server that make less sense at the databaase level. Linked Servers are instance level, so some architectural change is needed...
September 15, 2017 at 10:17 am
SHA-2 is available in Hashbytes() - https://docs.microsoft.com/en-us/sql/t-sql/functions/hashbytes-transact-sql
CHECKSUM() is MD5 (I think), which has a higher probability of collissions. Use HASHBYTES() instead.
September 15, 2017 at 10:09 am
webmaster @ this domain
September 15, 2017 at 9:51 am
Also check if you have trustworthy on in databases or cross database ownership chaining.
September 15, 2017 at 9:50 am
Linked servers aren't supported in Azure SDB.
Are you trying to perform distributed queries? I assume you don't want to do ETL?
September 15, 2017 at 9:47 am
That zip is a Powerpoint deck for the presentation. Not code.
What Russ likely does is have a number of jobs that check and monitor other servers and report back...
September 15, 2017 at 9:42 am
Redshift is a data warehouse that Amazon built, based on ParAccel technology. The platform and communications aren't standarized. The code you can run is SQL, which is fairly generic in...
September 15, 2017 at 9:35 am
SQL Server maintains time itself. However, it syncs periodically (every minute or less) with the underlying host OS, which maintains the time based on hardware crystals and optional NTP (network...
September 15, 2017 at 9:32 am
Travel prices/options are a mess. I sometimes have my wife book things since she seems to get better deals for some odd reason.
I looked on Hipmunk and saw...
September 15, 2017 at 9:20 am
Or missing. In baseball, 30% success is considered quite exceptional.
September 15, 2017 at 9:15 am
Viewing 15 posts - 6,481 through 6,495 (of 39,877 total)