Viewing 15 posts - 2,101 through 2,115 (of 7,483 total)
Amusing question; the use of RAND is an interesting distraction for a question that is really about UNION ALL and nothing else.
Tom
October 23, 2014 at 5:29 am
CELKO (10/16/2014)
.. BS such as not using variables or cross apply or adding a new column.
Avoiding variables is something in any books on functional programming today. Have you...
Tom
October 18, 2014 at 11:02 am
dbeyfyerd (10/17/2014)
Miles Neale (10/16/2014)
Tom
October 18, 2014 at 5:43 am
Luis Cazares (10/14/2014)
Tom
October 15, 2014 at 9:00 am
Steve Jones - SSC Editor (10/14/2014)
Is quoting and general access slow for anyone else today?
yes, sometimes pages take half a minute or more to lead - whether it's quoting or...
Tom
October 15, 2014 at 8:52 am
As many have already pointed out, the "correct" answer is bunk. There will be a syntax error because "column" is a reserved word. So the only option that...
Tom
October 15, 2014 at 8:00 am
Nice question - the fourth option is an amusing trap, but it didn't cTHIS IS CLEARLY SPAM.
Don't much like query hints, because they are an opportunity for the typical...
Tom
October 15, 2014 at 7:32 am
Koen Verbeeck (10/13/2014)
Easy enough for a Monday morning 😀
Yes, definitely.
Easy enough even for a Monday hangover :sick:
Tom
October 13, 2014 at 8:49 am
GilaMonster (10/10/2014)
TomThomson (10/10/2014)
This isnt true of Windows Firewall with Advanced Security, which does allow specific addresses
Which the OP said he's using (albeit with a incorrect word, he said advanced settings...
Tom
October 11, 2014 at 10:52 pm
Ville-Pekka Vahteala (10/10/2014)
More updated link.http://technet.microsoft.com/en-us/library/dd734783(v=ws.10).aspx
After reading I am still convinced that one can have inbound rule for limited list of ips on local port.
well, the second sentence on that page...
Tom
October 11, 2014 at 10:42 pm
GilaMonster (10/10/2014)
TomThomson (10/9/2014)
GilaMonster (10/9/2014)
Could someone who knows their way around firewalls please help this network admin out?http://www.sqlservercentral.com/Forums/Topic1624301-1550-1.aspx
what he's tring to do (and you said all firewalls should be able to...
Tom
October 10, 2014 at 9:21 am
Ville-Pekka Vahteala (10/9/2014)
TomThomson (10/9/2014)
Ville-Pekka Vahteala (10/9/2014)
1. Allow from scope (allowed IPs) to ports 1434 and 1433...
Tom
October 10, 2014 at 8:34 am
Duplicate post deleted
Tom
October 9, 2014 at 6:19 pm
GilaMonster (10/9/2014)
Could someone who knows their way around firewalls please help this network admin out?http://www.sqlservercentral.com/Forums/Topic1624301-1550-1.aspx
what he's tring to do (and you said all firewalls should be able to do) isn't...
Tom
October 9, 2014 at 6:18 pm
Ville-Pekka Vahteala (10/9/2014)
1. Allow from scope (allowed IPs) to ports 1434 and 1433 TCP and UDP...
Tom
October 9, 2014 at 6:13 pm
Viewing 15 posts - 2,101 through 2,115 (of 7,483 total)